IRish3538
05-08-2012, 12:58 PM
Hey all!
I have a worksheet that has several tables that get automatically populated.. at the end of the sub, i hide out all rows that dont't get used by using "for each cell in range". it works fine, but when it scans thru 100+ rows, its get kind of slow (even with screenupdating off).. any idea how i can do this better?
For Each Cell In Sheet8.Range("b4:b100")
Select Case Cell.Value
Case Is = 0
Cell.EntireRow.Hidden = True
End Select
Next
I have a worksheet that has several tables that get automatically populated.. at the end of the sub, i hide out all rows that dont't get used by using "for each cell in range". it works fine, but when it scans thru 100+ rows, its get kind of slow (even with screenupdating off).. any idea how i can do this better?
For Each Cell In Sheet8.Range("b4:b100")
Select Case Cell.Value
Case Is = 0
Cell.EntireRow.Hidden = True
End Select
Next