After running Find, need to goto column A of that row
 

I have a macro that runs Find, but I've added a wrinkle to it. It will
locate a cell. What I need is the proper code to move to Column A of
that line. I can't just move X number of cells to the left, because I
don't know which column the Find will land me in.
Something in the order of......... Go to column A of the same line.

Thanks,
J.O.

After running Find, need to goto column A of that row
 

You didn't post your code but
cells(activecell.row,1)
or
columns(1)

Sub findx()
x = Cells.Find("x").Row
Cells(x, 1).Select
End Sub
--
Don Guillett
SalesAid Software

"excelnut1954" wrote in message
ups.com...
I have a macro that runs Find, but I've added a wrinkle to it. It will
locate a cell. What I need is the proper code to move to Column A of
that line. I can't just move X number of cells to the left, because I
don't know which column the Find will land me in.
Something in the order of......... Go to column A of the same line.

Thanks,
J.O.

After running Find, need to goto column A of that row
 

Excellent. Thanks for the help.
J.O.
Don Guillett wrote:
You didn't post your code but
cells(activecell.row,1)
or
columns(1)

Sub findx()
x = Cells.Find("x").Row
Cells(x, 1).Select
End Sub
--
Don Guillett
SalesAid Software

"excelnut1954" wrote in message
ups.com...
I have a macro that runs Find, but I've added a wrinkle to it. It will
locate a cell. What I need is the proper code to move to Column A of
that line. I can't just move X number of cells to the left, because I
don't know which column the Find will land me in.
Something in the order of......... Go to column A of the same line.

Thanks,
J.O.