Storing selection & using the saved selection adress later
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)
"Peter Rooney" wrote:
You're welcome! Can I have a green tick, please? I wanna be an MVP! :O)
Regards
Pete
"Ozgur Pars" wrote:
Peter,
thank you very much it worked like a charm.
Ozgur
"Peter Rooney" wrote:
Ozgur,
Try this:
Dim WhereWasI As String
WhereWasI = Selection.Address
then later:
Range(WhereWasI).Select
Hope this helps
Pete
"Ozgur Pars" wrote:
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
|