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


---
Regards,
Norman


"Alistair Saldanha" <[email protected]> wrote in message
news:eM2of.12804$SM5.10883@dukeread02...
> 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
>
>
>

[Alistair Saldanha]

Thanks, Norman. That worked like a charm!

Alistair

"Norman Jones" <[email protected]> wrote in message
news:[email protected]...
> Hi Alistair,
>
> Try:
>
> Cells(ActiveCell.Row, 1).Select
>
>
> ---
> Regards,
> Norman
>
>
> "Alistair Saldanha" <[email protected]> wrote in message
> news:eM2of.12804$SM5.10883@dukeread02...
>> 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
>>
>>
>>
>
>

[Cutter]

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

[Alistair Saldanha]

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

Alistair


"Cutter" <[email protected]> wrote in
message news:[email protected]...
>
> That wouldn't be equivalent to using the Home key if there were columns
> "frozen" using Window > Freeze Panes.
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile:
> http://www.excelforum.com/member.php...fo&userid=9848
> View this thread: http://www.excelforum.com/showthread...hreadid=493654
>