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.


Thank you!



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question