Hiding multiple rows

[caliskier]

So I have several sheets that hide and unhide rows based on the word "unhide" in a cell.

The code I use is below, it seams to run very very slowly, is there a faster alternative to this?

Basically it takes a sheet, looks at each cell from 5 to 32 and hides or unhides based on the word "unhide" then it goes to the next sheet. Just takes forever.

Please Login or Register  to view this content.

[shg]

Try setting calculation to manual at the top of your code, and then reset it to automatic at the end.

[caliskier]

Try setting calculation to manual at the top of your code, and then reset it to automatic at the end.

That works, but I can't believe I left this out, works much faster...

Please Login or Register  to view this content.