Delete visible filtered rows

[jomili]

I've got a spreadsheet with 900K rows. In my Values column I have a lot of zero values, so need to delete those. My code for deleting them is below, but the deletion is VERY slow. Any ideas on how to speed it up? I've already turned off ScreenUpdating, Calculations, etc.

Please Login or Register  to view this content.

would it help if I sorted by Zeroes before deleting?

[romperstomper]

Yes, sorting should make it a lot faster.

[MarvinP]

Hi jomili,

Time to learn Power Query? If you do this often then it might be worth the effort. VBA and 900K rows will take a long time.... Sorry.

Here is an example of PQ. Created a table and removed zero values in less than a minute. Easy Peasy!!

Power Query remove zero values from table.xlsx

[jomili]

I'm certainly ready for PQ, but my organization isn't. That's one of the tools they haven't yet allowed us to use. But I keep pushing.

BTW, I redid my filter/delete macro as shown below. MUCH faster!

Please Login or Register  to view this content.