If you look at VBA's help for Selection, you'll see that it applies to the
application or window object.
You'll have to go through one of them to get it.
MsgBox Windows(1).Selection.Address & "--" & Windows(1).Caption
MsgBox Windows(2).Selection.Address & "--" & Windows(2).Caption
"Jim S." wrote:
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.
--
Dave Peterson