| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Equivalent Method to Control + END
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Equivalent Method to Control + END
Alice,
ActiveCell.SpecialCells(xlLastCell).Select ? use the macro recorder to recor the ctrl + ENd action. Cesar "Wayne Smith" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Equivalent Method to Control + END
That takes you to the last cell, so if the worksheet is blank it selects A1.
-- Michael Hopwood (Phobos) "Cesar Zapata" wrote in message ... Alice, ActiveCell.SpecialCells(xlLastCell).Select ? use the macro recorder to recor the ctrl + ENd action. Cesar "Wayne Smith" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Equivalent Method to Control + END
Sorry Cesar, I mis-read the original post, you are correct of course.
-- Michael Hopwood (Phobos) "Michael Hopwood" wrote in message ... That takes you to the last cell, so if the worksheet is blank it selects A1. -- Michael Hopwood (Phobos) "Cesar Zapata" wrote in message ... Alice, ActiveCell.SpecialCells(xlLastCell).Select ? use the macro recorder to recor the ctrl + ENd action. Cesar "Wayne Smith" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Equivalent Method to Control + END
ActiveSheet.Range("a1").Select
-- Michael Hopwood (Phobos) "Wayne Smith" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Equivalent Method to Control + END
Sorry, ignore my post, I mis-read your original post.
-- Michael Hopwood (Phobos) "Michael Hopwood" wrote in message ... ActiveSheet.Range("a1").Select -- Michael Hopwood (Phobos) "Wayne Smith" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Equivalent Method to Control + END
try
ActiveCell.SpecialCells(xlLastCell).Select -- Don Guillett SalesAid Software "Wayne Smith" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| Excel spin box - no Control tab in Format Control dialong box | Excel Worksheet Functions | |||
| Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
| Please post this thread a correct full method, method about | New Users to Excel | |||
| Please post this thread a complete correct method, method about te | New Users to Excel | |||
Hybrid Mode
