J Another word for array is matrixwhich is what a spreadsheet isThe Cells object refers to ele ments of a spreadsheetand a Cell consists of a row and a columnYouve been using arrays all along

To declare another dimension to an array, add another argument. The following creates an array of 10 rows and 20 columns: Dim myArray (1 to 10, 1 to 20)

This fills the first row:

This fills the second row:

and so on. Of course, this is very time consuming and could take a lot of lines of code. There are other ways to fill an array, which are discussed in the next section.

0 0

Post a comment