Inserting Values into an Array

Hi,

I have an array with 20 spaces and know the data I need to put into each slot is there a quicker way to do this than by doing

MyArray(0) = 1
MyArray(1) = 6
MyArray(2) = 10

etc,,,

Is it possible to do something like

MyArray = (1, 6, 10 etc)

It would save a lot of screen space for a start !

[BruceG]

You can use the Array function; the only drawback is that the Array function must be performed on the Variant data type (which is less efficient than the other data types). Here's the code:

Dim MyArray As Variant
    .
    . 
    .
MyArray = Array(1, 6, 10 ...)

When you reference MyArray, the low-bound index will be 0, and upper-bound will be # of items - 1.