title: Get range of selection in Excel without activate the sheet
body: <p>I have a quite huge and complex application based mainly on vba (+3500 lines of code): Its importing and analyzing the wishes for each teacher in my school (also wirtten in Excel). And then, the administrator can edit whatever setting/wish so next year planning of the teacher resources are complete.</p>
  
  <p>It works quite well. And functions almost like a database.</p>
  
  <p>I heavily use <em>Application.ScreenUpdating</em> and <em>Application.EnableEvents</em> to have a nice no-flicker-sensation (visually seeing change of sheets)
  but sometimes the program is updating several sheets in the same time and it causes flicker-troubles (the program structure is close to perfect, BUT is not perfect)  </p>
  
  <p>Is it possible, by any means to get the range of the selection in a sheet <strong>without having this sheet being activated</strong>? To get the idea: You are on Sheeet1 (Sheet1 <strong>activated</strong>) and want to get the (range of the) Selection of Sheet2.</p>
  
  <p>I've tried Sheets("Sheet2").Selection.Address or Sheet2.Seledtion.Address, but it doesn't work as Selection is an Application-object.</p>
  
  <p>Any ideas?</p>