Move to a specific cell

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

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...
 
mycell=activecell.address
range(mycell).select

However, these selections are almost always NOT necessary. What are you
trying to do?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Permutations andText to column problem 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Eliminating cells 3
Locking/unlocking cells based on column headers 5
Loop Through Text and Test for Scenarios Q 31
Removing duplicate rows and combining unique data 2
run a macro in excel when moving data 0
Inserting Formula moving down each row 2

Back
Top