title: VBA Excel: get part of range object
body: <p>I have a range <code>myRng</code> in shape of a column vector with 1346 cells.</p>
  
  <p>I would like to choose the first <code>100</code> cells of <code>myRng</code> and perform a <code>For each</code> operation: </p>
  
  <pre><code>Dim cell As Range
  For each cell in myRng(1:100)
      'Do something
  Next cell
  </code></pre>
  
  <p>What's a proper choice for <code>myRng(1:100)</code> to get this operation working?</p>