retaining cell address

[Dan]

sorry...premature send on the last post

I am trying trying to retain a cell address and refer back
and active that cell address and continue on. This is what
I have:

Dim st As String

If IsEmpty(ActiveCell)=True
st =ActiveCell.Address
do some things

Then I wnat to go back and select the saved st address and
start processing agin from the cell address.

Range st.Select

The reange line errors out. Thanks for the help.

 

[Bob Phillips]

See other post, my response still stands

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Dim st As String

If IsEmpty(ActiveCell)=True
st =ActiveCell.Address
do some things

Then I wnat to go back and select the saved st address and
start processing agin from the cell address.

Range st.Select

Unless you need the address as a string for some other purpose, why not

Dim st as Range

If IsEmpty(ActiveCell)=TrueSet
st = ActiveCell
' do your other stuff
st.select
End if

Your original way would work if you had:

Range(stAsAddressString).Select