Thread: Freeze panes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Freeze panes

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.