View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default VBA for Home key

Hi Alistair,

Try:

Cells(ActiveCell.Row, 1).Select


---
Regards,
Norman


"Alistair Saldanha" 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