PDA

View Full Version : Solved: Freeze Panes



Djblois
09-11-2006, 04:34 PM
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
09-11-2006, 06:38 PM
Try Application.Goto [A2]
ActiveWindow.FreezePanes = True
OR

[A2].Activate
ActiveWindow.FreezePanes = True

Djblois
09-14-2006, 04:54 AM
No that didn't help but I figured out you should always set Application.screenupdating = true before you freeze panes.