Thread
:
Move to a specific cell
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]