Can I declare an array with unknown size?

[charlieanfield]

Can I declare an array with unknown size?

Such as:
Dim strCode() As String

[Buzby]

Er.. Yes..! Then you use the Redim function to change the size of it at run time.

[crispin]

yes, and just to add to Buzby's post, use ReDim Preserve to keep all your existing array elements when you extend your array

i.e.

Dim s() as String 'string array
Dim i%

for i = 1 to 10

ReDim Preserve s(i)

Next i

[RCharlton]

To add an item to the array you would have to ReDim the array and use "Preserve" to keep the values:

Dim strCode As String
Dim topVar As Integer
Dim i As Integer
Dim YourNum as Integer

For i = 1 To YourNum
         topVar = UBound(strCode)+1
         ReDim Preserve strCode(topVar) As String
         strCode(topVar) = "This is the last item in the array"
Next