You would have to use the Split property in conjunction with the FreezePanes
property. See the VBA help file for Freeze Panes and Split for more details.

"Dave" wrote:

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.