Create a Constant Area in Worksheet Using FREEZE or VBA?

[Simonc64]

Is it possible, using the FREEZE options or via VBA to do this please.

Simple example - on a worksheet, say an area of A1 to G5, is it possible to "fix" this area so that when scrolling down, this area remains constantly in view regardless of how many rows you scroll down?

I'm guessing not, but you guys usually find a way!

Thanks

Simon

 

[My Aswer Is This]

Select range ("H6")
Then select the "View" Ribbon and then choose Freeze Panes.
On the top selection choose Freeze Panes

 

[Simonc64]

Thanks for the reply but that doesnt stop the up/down scrolling, just the right/left

 

[My Aswer Is This]

Thanks for the reply but that doesnt stop the up/down scrolling, just the right/left

I test all my suggestions

You want to always be able to see the Range("A1:G5")

If you followed my instructions this should work.

The active cell when you choose Freeze panes must be "H6"

 

[Simonc64]

yes i understand but it doesnt work

 

[My Aswer Is This]

yes i understand but it doesnt work

I have no other way to help

 

[My Aswer Is This]

Are you using a Apple computer?
What version of Excel are you using?