Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to restore the Selection that was in place at the time I started a
routine that changes the selection during its run. In other words I want something like dim saveSel as Range Set saveSel = Application.Selection .... do stuff that destroys the current selection then saveSel.Select And the problem with this is of course that the object to which saveSel refers has been destroyed in the meantime. What I actually want is to have saveSel be a range (or ref to a range) of cells that is set to whatever was selected originally. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
De-dup and retain new records only | Excel Worksheet Functions | |||
Copy Selection - Paste Selection - Delete Selection | Excel Programming | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Formula should retain | Excel Programming | |||
Retain, restore selection? | Excel Programming |