Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "Home" key be VBA programmed?
I need to recreate the "Home" key sequence in VBA in which the cursor
immediately move to column A. So far I've not been able to do so. The closest I've come is: Selection.End(xlToLeft).Select This onlyn recreates a "Ctrl Left", so, depending on the sheet, you may have to do a number of these to get to column A. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "Home" key be VBA programmed?
Simon,
Try something like Sub AAA() Cells(ActiveCell.Row, "A").Select End Sub "Simon Hughes" wrote in message news:xkHsd.719158$8_6.323824@attbi_s04... I need to recreate the "Home" key sequence in VBA in which the cursor immediately move to column A. So far I've not been able to do so. The closest I've come is: Selection.End(xlToLeft).Select This onlyn recreates a "Ctrl Left", so, depending on the sheet, you may have to do a number of these to get to column A. Is this possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "Home" key be VBA programmed?
Many thanks, that did it!
"Chip Pearson" wrote in message ... Simon, Try something like Sub AAA() Cells(ActiveCell.Row, "A").Select End Sub "Simon Hughes" wrote in message news:xkHsd.719158$8_6.323824@attbi_s04... I need to recreate the "Home" key sequence in VBA in which the cursor immediately move to column A. So far I've not been able to do so. The closest I've come is: Selection.End(xlToLeft).Select This onlyn recreates a "Ctrl Left", so, depending on the sheet, you may have to do a number of these to get to column A. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Can someone give me "simple" instruction for creating home budget | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |