Freezepanes

[jstevens]

Is there a condensed version of the following code?

Code: Select all

Rows("2:2").Select
    ActiveWindow.FreezePanes = True

Such as: Rows("2:2").FreezePanes = True

Thanks for taking a look,
John

[HansV]

No, FreezePanes is a property of the Window object, not of a Range.

And you need to select a range before setting FreezePanes to True - this is one of the few examples where Select is really necessary.