Try something like this:

NoofRowstoFroze = 1
Range("A" & NoofRowstoFroze + 1).Select
ActiveWindow.FreezePanes = True

Regards,
Stefi


€žJonWestcot€� ezt Ã*rta:

Hi all:

I'm trying to programatically freeze the heading rows on a particular
worksheet via a VBA program. All columns across the sheet should be frozen
so that, as I scroll up and down, the headings remain in place.

I know this involves a Pane object, but I can't seem to create one
programatically.

Can someone suggest a way to implement this where the row is variable yet it
encompases all the columns?

Thanks for any assistance you can send my way!

Jon