How do I freeze panes on a un-activated worksheet

[xlStar]

Worksheets("Sheet2").Activate
Range("I7").Select
ActiveWindow.FreezePanes = True

Why can't I use...

Worksheets("Sheet2").Range("I7").FreezePanes = True


The worksheet is Acitvate on Sheet1. YOu guys told me to reduced the "Select" and "Activate" method.

 

[HughLerwill]

Reduce not eliminate. Sometimes you may have to use them.

regards Hugh

 

[Zathras]

If you look in the help file (which you should always do before coming here) you will discover that the "FreezePanes" applies to the Window Object and not a Range Object.

Help File --> Search topic --> FreezePanes --> Click "Applies To" --> Read "Window Object"

The general admonition to reduce "Select" and "Activate" applies to worksheets and ranges, not windows.