Retaining cell address
 

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

Retaining cell address
 

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)


"Dan" wrote in message
...
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