Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set A1 on Top left Corner Q
How can I ensure that A1 is in the top left corner of my screen and
then the cursor is in K6? I've tried below but it doesn't work Sheets("Sheet1").Activate Range("A1").Select Range("K6").Select Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set A1 on Top left Corner Q
Your code will work if it;s in the correct place
Right click the sheet tab and then view code paste this in Private Sub Worksheet_Activate() Range("A1").Select Range("K6").Select End Sub Mike "Sean" wrote: How can I ensure that A1 is in the top left corner of my screen and then the cursor is in K6? I've tried below but it doesn't work Sheets("Sheet1").Activate Range("A1").Select Range("K6").Select Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set A1 on Top left Corner Q
On Apr 19, 10:20 am, Sean wrote:
How can I ensure that A1 is in the top left corner of my screen and then the cursor is in K6? I've tried below but it doesn't work Sheets("Sheet1").Activate Range("A1").Select Range("K6").Select Thanks Provided you don't have and splitwindows on your sheet this will work Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Select 'This is the same as using CTRL+HOME Range("K6").Select hth Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a cell appear in upper left (top left) corner of works | Excel Programming | |||
Claculation in left corner | Excel Programming | |||
Calculation in left corner | Excel Worksheet Functions | |||
Put a CommandBar on the left up corner of a cell | Excel Programming | |||
Cell A1 in Upper Left Corner | Excel Programming |