D
Dave
Hi,
I used the macro recorder when freezing panes, and it returned the following:
Range("A8").Select
ActiveWindow.FreezePanes = True
Is there a VBA way to tell Excel where to freeze, without selecting the cell?
eg: ActiveWindow.FreezePanes, Range("A8")
The above example errors, but is there a syntax for this?
Regards - Dave.
I used the macro recorder when freezing panes, and it returned the following:
Range("A8").Select
ActiveWindow.FreezePanes = True
Is there a VBA way to tell Excel where to freeze, without selecting the cell?
eg: ActiveWindow.FreezePanes, Range("A8")
The above example errors, but is there a syntax for this?
Regards - Dave.