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.