Macro stops working after rows/columns hidden call

[stefsj]

Hi,

I have been having issues with an old file of mine.

I have few different subs that have the rows().Hidden included in them. No matter what call I make, after the macro hides/unhides the rows it stops working and doesn't go to the next line of code. It could be as simple as this:

Sub ViewTestArea()
    Call SheetProtect
    If Rows("4:22").Hidden = True Then
        ActiveWindow.FreezePanes = False
        Rows("4:22").Hidden = False   'will stop after this 
    Else:
        Rows(32).Select
        ActiveWindow.FreezePanes = True
        Rows("4:22").Hidden = True   'or after this
        Cells(31, 1).Select
    End If
End Sub

I have few other calls that do the same thing so it is not just this one subroutine.

I believe there must be some bugs in the file to do this. I am reworking this file now from scratch and sometimes notice the same thing, but if I save it and reopen it again it will work normally.

Any ideas why is this happening?

 

[stefsj]

Greatly appreciate any responses!