title: Bilding 3x3 array from cells vba
body: <p>I have got a row with 9 cells, such as</p>
  <blockquote>
  <p>1,2,3,4,5,6,7,8,9</p>
  </blockquote>
  <p>I want to build a 3x3 matrix such as, for later do some operation with it</p>
  <blockquote>
  <p>1,2,3</p>
  <p>4,5,6</p>
  <p>7,8,9</p>
  </blockquote>
  <p>I have tried the following code</p>
  <pre><code>dim varr as variant
  for i = 0 to 1
      for j = 1 to 3
          varr(i, j-1) = activesheet.cells(1, 3+i+j))
      next j
  next i
  </code></pre>
  <p>which does not work (type mismatch), it is clear that I am not properly defining the array but i cannot figure it out.</p>
  <p>thanks</p>