Getting specific cell to be in upper left ?

  • Thread starter Thread starter Don Wiss
  • Start date Start date
D

Don Wiss

I'd like to have a specific cell, say A63, to be in the upper left corner.
This so after the macro runs the results are centered on the screen, Just
selecting the cell only makes sure that the cell is in view. If already in
view the screen doesn't move. If not, it tends to put A63 in the middle
left.

Don <donwiss at panix.com>.
 
see if this idea helps
Sub setit()
Application.Goto Range("c12")
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollColumn = 3
End Sub
 
Don,

Use Application.Goto with the second argument set to True. E.g.,

Application.Goto Range("A63"),True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Use Application.Goto with the second argument set to True. E.g.,

Application.Goto Range("A63"),True
Click to expand...

Very elegant. Thanks. (I just hope it also works in 97 when I get back into
the office.)

Don <donwiss at panix.com>.
 
Back
Top