Can "Home" key be VBA programmed?

[Simon Hughes]

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?

 

[Chip Pearson]

Simon,

Try something like

Sub AAA()
Cells(ActiveCell.Row, "A").Select
End Sub

 

[Simon Hughes]

Many thanks, that did it!

Simon,

Try something like

Sub AAA()
Cells(ActiveCell.Row, "A").Select
End Sub