View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT[_2_] JT[_2_] is offline
external usenet poster
 
Posts: 96
Default 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...