Simple macro to hide rows running very slowly

Hi all,

I've written this code (below) to hide rows that I don't need to be shown. I have an IF formula in column A that returns a 0 if the row should be hidden and a 1 if the cell should be shown.

The macro functions perfectly, it is just painfully slow (45 seconds+). What can I do to speed up the code?

Note: the UnhideAll code makes sure no cells are already hidden since the main HideRows macro only has the entirerow.hidden function, and no code to open cells that should be open. The UnhideAll macro runs fine by itself.. takes about 2 seconds on its own.

Thanks!

Please Login or Register  to view this content.

Originally Posted by Norie

Are you sure it's the hide code that's causing the slowdown?

It only takes a few seconds when I run it on it's own.

Could it be because you're running it in a blank sheet so all the cells by default will be 0?

When I remove the UnhideAll macro it still takes an eternity

New code:

Please Login or Register  to view this content.

It's running in 10 seconds now- thanks!