Dynamically Freeze Panes
 

Hello all,

I've a spreadsheet that I am working on that has row headings at
different points in the document for different/related data and was
wondering if it is possible to create a macro to dynamically freeze
panes when a certain row is reached when scrolling?

Row 1 has the column heading for the first chunk of data, then row 400
has the headings for the next chunk of data. I'd like to be able to
scroll down the page with row 1 frozen, until I scroll past Row 399,
then row 400 gets frozen.

Thoughts?


Thank you!


Steven

Dynamically Freeze Panes
 

May be by using sheets_change event, monitoring target row number.

"Steven B" wrote in message
...
Hello all,

I've a spreadsheet that I am working on that has row headings at
different points in the document for different/related data and was
wondering if it is possible to create a macro to dynamically freeze
panes when a certain row is reached when scrolling?

Row 1 has the column heading for the first chunk of data, then row 400
has the headings for the next chunk of data. I'd like to be able to
scroll down the page with row 1 frozen, until I scroll past Row 399,
then row 400 gets frozen.

Thoughts?


Thank you!


Steven