I first came across this Microsoft Excel vba error back in 2009, when the vba dialog box interrupted macro processing with the message "Code Execution Has Been Interrupted" and it quite literally did my head in.It's a weird error because it doesn't have an error number and in fact it isn't really an error but rather a bug for which a lot of misinformation existed on … [Read more...] about Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem
Most Popular
VBA Class Module Example – Better VBA With Objects
How to use Class Modules in Excel VBA, check out the video tutorial then the article for some extra depth. Get VBA Class Module Spreadsheet Here Also get updates when new blog or video tutorials are released. VBA Class Modules - Some Essential background Class modules are … [Read more...] about VBA Class Module Example – Better VBA With Objects
Excel Advanced Filter – Criteria to Show Blank Cells
Today I had a problem in Excel that crops up quite often, namely how to filter to find blank cells or how to filter to exclude blank cells. … [Read more...] about Excel Advanced Filter – Criteria to Show Blank Cells
Excel 2010 Advanced Filter Tutorial
The Excel 2010 Advanced Filter adds database functionality to Excel, you can query by example and style custom reports with this feature. … [Read more...] about Excel 2010 Advanced Filter Tutorial
Power Excel vba secret, avoid using select
I see it all the time, code that selects one thing, then another, then selects something else in order to navigate and write data in an Excel spreadsheet. Instead understand that the Microsoft Excel object model and your vba code will be more professional, robust and maintainable if you don't select anything but instead interact with the Excel objects … [Read more...] about Power Excel vba secret, avoid using select