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.

Hi Jim
AFAIK you have to activate/select the sheet first. You may hide this
with diaabling the screenupdating

--
Regards
Frank Kabel
Frankfurt, Germany


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.

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