Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to a specific cell
When my macro meets a certain condition, I create a
variable to identify the row in Col. A that I am in. currentrow = activecell.row I then move to A1 and move down through Col A. until I find a cell that meets additional criteria. At this time, the macro performs a subroutine. Once the subroutine is completed, I want to move back to the cell in Col A that I was in. I tried the following: Range(Cells(currentrow,0)).Select to move back but that is not working for me. I would appreciate any suggestions to move back to cell I was in. Thanks for the help... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to a specific cell
mycell=activecell.address
range(mycell).select However, these selections are almost always NOT necessary. What are you trying to do? -- Don Guillett SalesAid Software "JT" wrote in message ... When my macro meets a certain condition, I create a variable to identify the row in Col. A that I am in. currentrow = activecell.row I then move to A1 and move down through Col A. until I find a cell that meets additional criteria. At this time, the macro performs a subroutine. Once the subroutine is completed, I want to move back to the cell in Col A that I was in. I tried the following: Range(Cells(currentrow,0)).Select to move back but that is not working for me. I would appreciate any suggestions to move back to cell I was in. Thanks for the help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cursor to specific cell from a specific cell | Excel Discussion (Misc queries) | |||
macro - how to move to a specific cell and repeat | Excel Worksheet Functions | |||
How do I move to a specific cell in Excel? | Excel Discussion (Misc queries) | |||
Move text that is a specific color to a different cell | Excel Worksheet Functions | |||
Move curser to specific cell when closing | Excel Worksheet Functions |