Determining the Selection on a non-active Sheet?
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. |
Determining the Selection on a non-active Sheet?
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. |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com