Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
type of selection if selection is chart | Excel Programming | |||
Object Type of a selection... counting rows in a selection | Excel Programming | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming |