View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
excelnut1954 excelnut1954 is offline
external usenet poster
 
Posts: 175
Default 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.