Determining the Selection on a non-active Sheet?

J

Jim S.

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.
 
F

Frank Kabel

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

Dave Peterson

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
 
Top