I was hoping someone might have a quicker way of looping through a range?
I use the following to loop through the cell value in D1:D251. If the value in the cell is greater than zero it does nothing, if less it hides the row and moves on to the next.
Only problem is that it take yonks to loop through.......aggghhh people are way to impatient to wait 50 or 60 seconds.
Selection.EntireRow.Hidden = False
Application.ScreenUpdating = True
Do While Counter < 251
Counter = Counter + 1
If ActiveCell.value > 0 Then
Selection.EntireRow.Hidden = True
BTW: XL97 WIN98.