VB help please

[shyamvinjamuri]

Is there a way to Freeze Panes (Freeze first row) with VB?
I am using Excel 2007

Thanks

 

[MrKowz]

Try:

    Range("A2").FreezePanes = True

 

[shyamvinjamuri]

I tried Range("A2").FreezePanes = True
It gives me Run-time error '438' Object doesn't support this property or method.

 

[MrKowz]

I think this is one of those cases where you need to select a cell. Tested, and confirmed, the following.

    ActiveWindow.FreezePanes = False
    Range("A2").Select
    ActiveWindow.FreezePanes = True

 

[shyamvinjamuri]

Perfect.
Thank you