title: Reset UsedRange without activating the sheet
body: <p>I am reviewing some code that loops through a large number of worksheets and refreshes data connections in each one. Since the tables can change size by quite a lot when refreshed, it is necessary to reset the used range on each sheet and the current code in place is as follows:</p>
  
  <pre><code>sh.Activate
  ActiveSheet.UsedRange
  Sheets(OriginalSheet).Activate
  </code></pre>
  
  <p>Simple question - I know that just running <code>sh.UsedRange</code> doesn't work, but is there any other way of resetting the used range without activating the sheet?</p>