How to use array in VBA ?

[aviadht]

how can i define and use "array"in vba.

for example: i want an array that can get 27 values.
The values should be strings.

after, i will take the array and implement in in a for loop in order to make the code writing shorter.

Thanks,
Aviad

 

[Comfy]

Dim ArrayName (1 To 27) As String

There is lots of useful info here:
http://www.cpearson.com/excel/vbaarrays.htm