Simple macro takes a long time to execute

Hello!

I have a small problem with a simple macro that I have assigned to a button. The thing is: I just want it to hide empty rows. This works perfectly, but running the program on 200 rows takes about 15 seconds to run, which seems incredibly long to me.

I was wondering if I made a mistake in the macro, or is there a way to make it much... lighter?

Thank you in advance,

Carel

Please Login or Register  to view this content.

Hi Carel,
try this

Please Login or Register  to view this content.

Ah that worked perfectly, it runs like a charm now! Thank you very much, I'm going to examine that bit of code!

Instead of loop rather use SpecialCells:

Please Login or Register  to view this content.

Hi zbor, thanks!

It did not work, though, maybe because all cells are filled with formulas, and thus not seen as Blank Cells?

Everything works great, but I still ran into one tiny problem:

If, due to a formula in one of the hidden cells, the value of the cell changes from 0 to a higher value, I'd like that - if I run the macro - this row is unhidden. However, this does not seem to work with this code - it just hides columns that are not yet hidden, and not the other way around. Any idea how to make that work?

Thanks!

Alright, solved that as well. Everything works fine. Thank you very much for your assistance nilem and zbor!

The final code that I used:

Please Login or Register  to view this content.