Determining the Selection on a non-active Sheet?

  • Thread starter Thread starter Jim S.
  • Start date Start date
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.
 
Hi Jim
AFAIK you have to activate/select the sheet first. You may hide this
with diaabling the screenupdating
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

clear all sheets code 4
Run macro from active workbook whose name keeps changing 20
Selection on a non-active sheet? 2
ActiveCell on inactive sheet 8
getting the selected range and active cell of a non active worksheetsheet 7
Determining the Active Worksheet 2
copy text and logo from protected, hidden sheet 1
conso macro 0

Back
Top