Thanks, Stefi, for the reply. Much appreciated!

Jon


"Stefi" wrote in message
...
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