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.

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
(E-Mail Removed)
"excelnut1954" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>

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
> (E-Mail Removed)
> "excelnut1954" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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.
> >