Getting specific cell to be in upper left ?
 

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.

Getting specific cell to be in upper left ?
 

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

--
Don Guillett
SalesAid Software

"Don Wiss" wrote in message
...
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.

Getting specific cell to be in upper left ?
 

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


"Don Wiss" wrote in message
...
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.

Getting specific cell to be in upper left ?
 

On Tue, 11 Nov 2003 18:46:53 -0600, Chip Pearson wrote:

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

Application.Goto Range("A63"),True

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

Don <donwiss at panix.com.

Getting specific cell to be in upper left ?
 

It works in 9

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Getting specific cell to be in upper left ?
 

It does.

Regards,
Tom Ogilvy

Don Wiss wrote in message
...
On Tue, 11 Nov 2003 18:46:53 -0600, Chip Pearson
wrote:

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

Application.Goto Range("A63"),True

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

Don <donwiss at panix.com.