Freezing Panes

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi All

I have a question about freezing panes. I know that you can freeze panes at
one point in your spreadsheet (Say the first 5 rows) whereby you can scroll
down as much as you want and the top 5 rows stay constant on your spread
sheet.

What I am looking to do is to freeze to points on a spreadsheet so that you
can scroll only through a defined area. For example:

Rows 1 through 5 are frozen
Rows 200 through 205 are frozen

So you can only scroll in between rows 6 and 199. That was my column
headers and my totals for the information that I am entering are always
visible on the screen and I can only scroll in between the two frozen pane
area.

Is this possible, either through excel itself or through some variation of
coding?

Any and all comments and assistance with this would be greatly appreciated
and I thank all responses in advance.

Thank you,

Jeff
 
Hi Jeff,

See if this does what you want. Adjust to your range. Second line clears
the restriction.

Sub FreezeIt()
ScrollArea = "A5:H25"
'ScrollArea = ""
End Sub

HTH
Regards,
Howard
 
Back
Top