Storing selection & using the saved selection adress later

[Guest]

Hello,
I am trying to save the current selection adress as a variable (or name) &
make some calculations and then make excel reselect the original selection.
Just to clarify this procedure is intended to be used in different kinds of
workbooks/users.

Thanks in advance for your time and help,
Ozgur

 

[Guest]

Ozgur,

Try this:

Dim WhereWasI As String
WhereWasI = Selection.Address

then later:

Range(WhereWasI).Select

Hope this helps

Pete

 

[Guest]

Peter,
thank you very much it worked like a charm.

Ozgur

 

[Guest]

You're welcome! Can I have a green tick, please? I wanna be an MVP! :O)

Regards

Pete

 

[Guest]

Peter sure you definately saved my day... is it enough that I asnwer the "Did
this post answer the question" as yes?
I ask this because I did post several "yes" answers and the green tick did
not appear(at least to me)

 

[Guest]

Ozgur,

I got my tick. Thanks very much! Now I'm into double figures!

Pete