Hi there!
I have a problem as rows which should hide are not hiding.
The code is the following (it is part of a much bigger program):
For b = 13 To 54
Select Case b
Case 13 To 22, 30 To 33, 38 To 41, 46 To 49, 52 To 54
If Cells(b, 1) = "" Then Cells(b, 1).EntireRow.Hidden = True
End Select
Next b
The strange thing is if I set a breakpoint in the line where the for next loop begins, run the sub and then keep going forward pressing F8 the rows are being hidden correctly. When I let the sub proceed till end it they stay hidden and everything is allright.
But if I let the program work completely by itself without breakpoint, the rows are not being hidden.
I am really losing a lot of time with this now and see no error in the code....
Bookmarks