Solved: Freeze Panes

[Djblois]

Why does this code sometimes perform correctly and freeze the rows above and sometimes it freezes in the middle of the screen.

Range("A2").Select
ActiveWindow.FreezePanes = True

[johnske]

Try Application.Goto [A2]
ActiveWindow.FreezePanes = True
OR

[A2].Activate
ActiveWindow.FreezePanes = True

[Djblois]

No that didn't help but I figured out you should always set Application.screenupdating = true before you freeze panes.