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