Equivalent Method to Control + END

  • Thread starter Thread starter Wayne Smith
  • Start date Start date
W

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
 
Alice,


ActiveCell.SpecialCells(xlLastCell).Select

?

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

Cesar
 
That takes you to the last cell, so if the worksheet is blank it selects A1.
 
Sorry Cesar, I mis-read the original post, you are correct of course.
 
You must log in or register to reply here.

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

Similar Threads

Ribbon's equivalent to CommandBars.ActionControl 5
insert worksheet shift 11 tab 2
Command Button Question 8
potential bug in copy method 3
Type Mismatch error when trying to generically set ComboBox to aComboBox variable 7
Controlling auto-filter with VBA 1
Asci equivalent of soft return (alt+enter) 3
How to get Last Key or Key-Combo Pressed (Not Event)? 0

Back
Top