Freezepanes

jstevens
GoldLounger
Posts: 2631
Joined: 26 Jan 2010, 16:31
Location: Southern California

Freezepanes

Post by 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
Regards,
John

User avatar
HansV
Administrator
Posts: 78774
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Freezepanes

Post by 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.
Best wishes,
Hans