title: Want to extract two-dimensional array from three-dimensional array
body: <p>I'm populating a multi-sheet excel spreadsheet from a Lotus Notes database using a LotusScript agent in Notes.
  In order to optimise the code, I'm building all the data in an array first, then dumping it into Excel, as it's much quicker to write an array in one go, than write each cell or row individually.</p>
  
  <p>So I have a three dimensional array holding the data defined by</p>
  
  <pre><code>ReDim sheetData(sheets,rows,columns)
  </code></pre>
  
  <p>I have no problem populating the array, using view navigator entries, but when I come to write to Excel, I wanted to do </p>
  
  <pre><code>For c = 0 to sheets
     With xlSheet(c+1)
        .Range(.Range.Cells(1,1) , .Range.Cells(rows+1, columns+1).Value = sheetData(c)
     End With
  Next
  </code></pre>
  
  <p>That doesn't work, obviously, because I need to give three subscripts for sheetData.</p>
  
  <p>So what's the best way to extract the rows and columns data?</p>