Use a for loop to generate arrays

[Waterloo1]

Hi, I need to use a for loop to generate 3 different arrays, how can I do that?
i.e calendar0(), calendar1() and calendar2().



For i = 0 to 2
...code to generate the 3 calendar arrays...
Next

[rdoekes]

if all the calendar arrays have the same number of elements you could opt for a multidimension array.

Dim AllCalendars(4,2)

For i = 0 to 2
AllCalendars(0,i) = "some value"
'etc...
Next