Set A1 on Top left Corner Q

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

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
 
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
 
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
Click to expand...

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
 
Back
Top