VBA Hiding rows

[smithani]

Hey does anyone know how I can make the following code more efficient, it seems to take a really long time to do this, the code hides the row if there is no data in the coloumn, it does it for 3 different sections:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[VBA Noob]

Try adding at the start of the code

Please Login or Register  to view this content.

and then

Application.ScreenUpdating = true

at the end

VBA Noob

[smithani]

thanks, I tried that...but its still terribly slow...excel keeps freezing up

[VBA Noob]

Maybe

Please Login or Register  to view this content.

[royUK]

It would probably be much faster to use AutoFilter, does your data have header rows?. This will be faster for empty cells.

Please Login or Register  to view this content.