Freezing a row

[Guy Cohen]

Hi all.
I am using VB6 to generate an EXCEL report.
I would like to set "Window->Freeze panes" to row number 1 by code.
How do I do that?
TIA
Guy

 

[Don Guillett]

Have you tried the macro recorder? A good way to learn

 

[Guy Cohen]

No I have not
I am a newbie
BTW- If possible please teach me how to do it from VB
Guy

 

[Tom Ogilvy]

vb or Excel VBA would be the same

Activesheet.rows(2).Select
ActiveWindow.FreezePanes=True