Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Go to goto - FIND | Excel Discussion (Misc queries) | |||
On error from Find, GoTo E | Excel Discussion (Misc queries) | |||
Goto or Find a Date in a Sheet | Excel Discussion (Misc queries) | |||
find the last Fred and goto cell | Excel Worksheet Functions | |||
Find then GoTo problem code | Excel Programming |