Storing selection & using the saved selection adress later
 

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

Storing selection & using the saved selection adress later
 

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

Storing selection & using the saved selection adress later
 

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

Storing selection & using the saved selection adress later
 

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

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

Storing selection & using the saved selection adress later
 

Ozgur,

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

Pete



"Ozgur Pars" wrote:

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