Dynamically Freeze Panes

[Steven B]

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

 

[KC]

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