Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the little black triangle in the upper left corner of a cell | New Users to Excel | |||
Hyperlink to cell and have it appear at top upper left hand corner | New Users to Excel | |||
Green Triangle in Upper Left Corner of Cell | New Users to Excel | |||
grey dot in left upper corner of cell | Excel Discussion (Misc queries) | |||
How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) |