Thread
:
After running Find, need to goto column A of that row
View Single Post
#
3
Posted to microsoft.public.excel.programming
excelnut1954
external usenet poster
Posts: 175
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.
Reply With Quote
excelnut1954
View Public Profile
Find all posts by excelnut1954