Freeze moving rows

[Valentine]

So I have an Excel spreadsheet that has 4 title rows that I want to freeze when they are at the top of the screen when scrolling. For easy lets say my title rows are 1, 100, 200, and 300. When I scroll down the spreadsheet I want row 1 frozen until I hit row 100 which I want to take over as the frozen row and then again at 200 and so on. How do I do tihs?

 

[arnelgp]

maybe split your worksheet by 100 rows and put each to each own Sheet?

 

[Valentine]

No I am trying not to split, I want it to scroll down through the data.

 

[Gasman]

So I have an Excel spreadsheet that has 4 title rows that I want to freeze when they are at the top of the screen when scrolling. For easy lets say my title rows are 1, 100, 200, and 300. When I scroll down the spreadsheet I want row 1 frozen until I hit row 100 which I want to take over as the frozen row and then again at 200 and so on. How do I do tihs?

Need to look at the perhaps worksheet change event and keep track of the row number.