freeze header row in Excel.

[RAK]

I found "ActiveWindow.FreezePanes = True" but I cannot get it to work..

please help
thanks
Roy

[stanl]

I found "ActiveWindow.FreezePanes = True" but I cannot get it to work..

please help
thanks
Roy

Maybe

oXL.ActiveWindow.FreezePanes = @True


where oXL is the Excel Object.  This is a fairly common issue with translating macros ino WB. Macro and VBA code allows you to shortcut the references, while WB needs the full reference.

[RAK]

You got it! You have also helped me with additional conversion from VBA to WB. I now understand the need to include the "external" program call. I get it now.

thanks Stanl!