Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining the Selection on a non-active Sheet?
Hi,
Is there a way to determine the range of cells that have been selected on "another" sheet, without first activating it? I want to be able to say something like: Dim theSel as Range Set theSel = Worksheets("A nonactive sheet").Selection but this obviously fails. Any way to accomplish the equivalent without activating or selecting that other sheet? Thanks, Jim S. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection starting from active cell | Excel Discussion (Misc queries) | |||
Active range/selection? | Excel Worksheet Functions | |||
Determining active conditional format of one cell | Excel Programming | |||
Determining Active Row Number | Excel Programming | |||
Determining Active Row Number | Excel Programming |