For Each Loop (Make it Faster)

Originally Posted by JimBobBowie

Depending on the version of excel you are using the simplest thing you can do to speed things up is to turn off auto calculation while running this macro. You can do this manually or via code. Currently each time you hide a row the sheet will recalculate. This takes a long time.

Application.Calculation = xlManual

For each ce in rng
If ce.value = "Hide" then
ce.entirerow.hidden=true
end if
next

Application.Calculation = xlAutomatic

JimBobBowie

Thank-you JimBobBowie,
Yes, I have trying turning off calculation and screenupdating also. But it's still slow. I think it's because the code inherently is slow because it goes down the column one cell at a time and evaluates whether or not it's a "Hide".

Regards,
Ricky