Quick One: How to select the area of screen in view

[Mightyginger]

A1 is normally the cell in the top left corner of the screen - is there any way, in vba, that I can basically place a specific cell in that corner - i.e. specify which part of the spreadsheet a user is looking at? I've tried naming a cell as a range and selecting that, and although it does move you over that area, I want to choose EXACTLY which column is at the left of the window and which row is at the top. Is this possible?

Oh, also just while I'm at it - is there a way of freezing both horizontal and vertical panes please? (I've managed to freeze the horizontal pane so far).

Thanks for your help!!!!



Neil.

 

[RoyVidar]

Hi!

To place i e x135 in the upper left corner:

application.goto range("x135&quot, true

HTH Roy-Vidar

 

[SkipVought]

On Q2 - select a cell just below and to the right of the area you want to freeze -- then freeze!



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Mightyginger]

thanks guys - once again to my rescue!!!



Neil.