I have an issue which I'm getting around by running two macros at the moment but I'm sure it's a fairly simple fix and would like to combine the macros.
I have a very large spreadsheet with 147k rows and 54 columns. A lot of the data is unnecessary and so the first step of my macro is to delete all but four relevant columns.
It then does some sorting and text to numerical conversion before completing.
What I noticed was that if I saved after this step - my next macro ran a LOT faster.
(This one just deletes specific lines).
I'm guessing this is related to the initial filesize being changed by my save and without it - excel still see's it as large despite my deletion of the majority of columns.
Anyone any idea as to how I could introduce code to combine the macros but keep the speed?
Bookmarks