Fill an array in one operation

[BruceG]

You can use the Array function (the data type of the array must be variant, and it will start at index 0):

Dim week as Variant

week = Array("Sunday", "Monday", "Tuesday", .... "Saturday")

week(0) will refer to "Sunday", week(6) will refer to "Saturday".