Set A1 on Top left Corner Q

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
 
M

Mike

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top