Equivalent Method to Control + END

[Wayne Smith]

Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control + End
key combination on a worksheet?

TIA
Alice

 

[Michael Hopwood]

ActiveSheet.Range("a1").Select

 

[Cesar Zapata]

Alice,


ActiveCell.SpecialCells(xlLastCell).Select

?

use the macro recorder to recor the ctrl + ENd action.

Cesar

 

[Michael Hopwood]

That takes you to the last cell, so if the worksheet is blank it selects A1.

 

[Don Guillett]

try
ActiveCell.SpecialCells(xlLastCell).Select

 

[Michael Hopwood]

Sorry, ignore my post, I mis-read your original post.

 

[Michael Hopwood]

Sorry Cesar, I mis-read the original post, you are correct of course.