Storing selection & using the saved selection adress later

[Ozgur Pars]

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

[Peter Rooney]

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

[Ozgur Pars]

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

[Peter Rooney]

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

[Ozgur Pars]

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

[Peter Rooney]

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