How to Speed Up a Macro – Part 2

Feb 3, 2013

This follows on from How to Speed Up a Macro – Part 1 This week’s problem was a huge Excel file (20MB – not mine BTW!) that contains lots of data and 2 small macros. The first macro runs through several thousand rows of data, deleting rows that match...

How to Speed Up a Macro – Part 1

Feb 3, 2013

This week’s problem was a huge Excel file (20MB – not mine BTW!) that contains lots of data and 2 small macros. The first macro runs through several thousand rows of data, deleting rows that match a given criteria. The second macro takes the remaining...