VBA for Home key

[Alistair Saldanha]

Greetings to all!

My question: What is the Excel VBA equivalent of hitting the Home key?
"Selection.End(xlToLeft).Select" won't go all the way to the left if it
encounters a blank cell enroute.

Alistair

 

[Norman Jones]

Hi Alistair,

Try:

Cells(ActiveCell.Row, 1).Select

 

[Alistair Saldanha]

Thanks, Norman. That worked like a charm!

Alistair

 

[Cutter]

That wouldn't be equivalent to using the Home key if there were column
"frozen" using Window > Freeze Panes

 

[Alistair Saldanha]

Not a problem in my current situation but thanks for pointing that out.

Alistair