Dynamically Freeze Panes

S

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
 

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

Similar Threads

Unable to freeze panes 15
insert new row every day. 2
Freeze Panes 2
Excel 2007 - freeze multiple panes? 2
Mail Merge Help 1
Trying to freeze heading rows on a sheet 5
Freeze Panes loss 3
Freeze Panes 5

Top