| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a cell appear in upper left (top left) corner of works
Whenever I use the Range("A28").Select command, it selects and makes A28 the
focus, but it puts appears in about the the middle of the worksheet, with rows visible both above and below it. How do I select A28, AND move A28 up to the top left corner of the sheet, so there are only the rows below it visible? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make a cell appear in upper left (top left) corner of works
One way:
Option Explicit Sub testme() Application.Goto ActiveSheet.Range("a28"), scroll:=True End Sub jeff wrote: Whenever I use the Range("A28").Select command, it selects and makes A28 the focus, but it puts appears in about the the middle of the worksheet, with rows visible both above and below it. How do I select A28, AND move A28 up to the top left corner of the sheet, so there are only the rows below it visible? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make a cell appear in upper left (top left) corner of w
Excellent!!! Thank you
"Dave Peterson" wrote: One way: Option Explicit Sub testme() Application.Goto ActiveSheet.Range("a28"), scroll:=True End Sub jeff wrote: Whenever I use the Range("A28").Select command, it selects and makes A28 the focus, but it puts appears in about the the middle of the worksheet, with rows visible both above and below it. How do I select A28, AND move A28 up to the top left corner of the sheet, so there are only the rows below it visible? Thanks -- Dave Peterson |
| 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 | |||
| grey dot in left upper corner of cell | Excel Discussion (Misc queries) | |||
| Returning Cell to Upper-Left-Most Corner | Excel Programming | |||
| Cell A1 in Upper Left Corner | Excel Programming | |||
Linear Mode
