To work with arrays in Excel your have some options:
- Select a range of [10Rows] x [1Columns] cells.
- Press F2 to go into formula mode.
CTRL+SHIFT+ENTERto make it a array formula.
Besides beeing quite difficult to master, there also the problem that you need to know the size of the array.
Use Dump() or Resize()
There are two macro functions in SeoTools to simplify working with arrays in Excel:
Dump takes an array and Dumps it on the spreadsheet.
Resize automatically creates an Excel array formula.