I tried that once before and never found a way of doing it- I don'
think it can be done. What you can do though is create an arra
(matrix) and loop though the elements- Be aware the first element i
indexed as zero not 1.

Dim arMyArray(2) as Long

For i = 0 to 2
armyarray(i) = i*5
next i

The variable will be:

arMyArray = (0,5,10)

and to get the values back out just specify the index-

arMyArray(1) = 5

Dunca

--
Message posted from http://www.ExcelForum.com