title: Selecting range of data on hidden sheet without .Activate
body: <p>I'm populating a combobox list via a hidden worksheet ("Data") where I have a few lists stored.</p>
  
  <p>I currently select the range as below:</p>
  
  <pre><code>Dim arr() As Variant
  
  Worksheets("Data").Activate
  
  arr = Range("D2", Range("D2").End(xlDown).End(xlToRight))
  
  cboBox.List = arr
  </code></pre>
  
  <p>However, this obviously activates the hidden sheet "Data". How can I select that same range without selecting/showing the hidden sheet?</p>
  
  <p>I tried using variants of...</p>
  
  <pre><code>arr = Sheets("Data").Range("D2", Range("D2").End(xlDown).End(xlToRight))
  </code></pre>
  
  <p>... to avoid having to activate the sheet, but that doesn't work.</p>
  
  <p>I think it's to do with calling the "D2" range twice for xlDown then xlToRight but I can't work out what the correct syntax needs to be.</p>
  
  <p>Many thanks.</p>
  
  <p>EDIT: YowE3K's suggestion worked:</p>
  
  <p><code>arr = Sheets("Data").Range("D2", Sheets("Data").Range("D2").End(xlDown).End(xlToRight))</code></p>