title: Excel VBA - Shifting values of an array of numbers by a constant without looping
body: <p>Is there a way to add a constant to an array of numbers in Excel VBA (Excel 2007) without looping?</p>
  
  <p>For instance, I have the following array:</p>
  
  <pre><code>MyArray = (1,2,3,4,5)
  </code></pre>
  
  <p>And I want to obtain:</p>
  
  <pre><code>MyArray = (2,3,4,5,6)
  </code></pre>
  
  <p>Without looping.</p>
  
  <p>On the Spreadsheet, if the values are in cells <code>A1:A5</code>, I can select <code>B1:B5</code> and enter the array formula <code>{=A1:A5+1}</code></p>
  
  <pre><code>MyArray = MyArray + 1
  </code></pre>
  
  <p>does not seem to work (Type mismatch error).</p>
  
  <p>Any ideas?</p>