i would just do something like this
myRow = ActiveCell.Row
Cells(myRow, 1).Select
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"ORLANDO V" wrote:

Anyone know how I can offset from the active cell to the leftmost column a.

I have been trying Selection.End(x1Left).Select but that doesn't work since
I don't know how many columns to the left column a is each time. Sometimes
it may be 65 columns to the left, othertimes just a few columns to the left.

What command would you use?
Thank you.