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.