| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ctrl+End with VBA
I believe this 1-line code should do what you're looking for.
ActiveCell.SpecialCells(xlLastCell).Select or as an alternative, this 1 line should work also. ActiveCell.SpecialCells(xlCellTypeLastCell).Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
| How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| Redefining the Ctrl [ and Ctrl ]s short cut with OnKey? | Excel Programming | |||
| Disabling Ctrl-PgUp and Ctrl-PgDn | Excel Programming | |||
Hybrid Mode
