Retaining cell address

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I am trying to retain the a cell address so that after I
perform a few other routines I can go back to that cell
(activate) and do other things. This is what I have and
its not working.

Dim st As String

If IsEmpty(ActiveCell)=True
 
Surely, you need to save the cell in a variable, such as

Dim oCell as Range

Set oCell = Activecell
' do your stuff elsewhere
oCell.Select

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

retaining cell address 2
VBA set thick borders around non empty cells in range 0
Populating a range of empty cells with usernames 4
Code to Concat a row in loop 2
Copy Active Range from one workbook to another 1
Compile Error: Expected:( 2
ActiveCell on inactive sheet 8
Entering data from a userform into multiple sheets 2

Back
Top