Getting specific cell to be in upper left ?

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>.
 
D

Don Guillett

see if this idea helps
Sub setit()
Application.Goto Range("c12")
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollColumn = 3
End Sub
 
C

Chip Pearson

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
 
D

Don Wiss

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>.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving Active Cell to Upper Left Hand Corner of Screen 2
How to make A1 the active cell in all visible worksheets ? 3
choosing cell to top left of visible window 3
Cell A1 in Upper Left Corner 3
scroll so that the upper left cell in a range moves to the upper left of the active window 6
Button to change view location 11
Returning Cell to Upper-Left-Most Corner 7
What is small green triangle in upper left corner of cell? 6

Top