Moving to extreme left of a row in VBA

[singcbl]

I like to know how do you move the active cell to the extreme left side of a row when in between there are blank cells. I tried using the macro recorder to record this action but the result is not what I want. What I want is whenever I execute this macro the cursor will move to the extreme left end. Usually by pressing the "Home" key will do the trick but not in macro recording mode.

 

[Andrew Poulsom]

Do you mean?

Cells(ActiveCell.Row, 1).Select

 

[singcbl]

Andrew,

Thanks!
Yes, that's what I was looking for.