Set A1 on Top left Corner Q

[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

 

[Guest]

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

 

[PMC1]

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