Missing array subscript or collection index for: <name>
Either of two conditions could have caused this error:
- You included empty parentheses in a reference to the return value
of a function or property. This is not allowed. Assuming that the
function or property returns a Variant containing an array, list,
or reference to a collection, you can either remove the empty parentheses
or insert the appropriate subscript or subscripts. Removing the parentheses
makes the reference be to the entire array, list or collection, while
including the subscript or subscripts makes the reference be to a
single element in the array, list, or collection. For example:
Dim anArray(5) As Variant Function MyFunction(someArray()) As Variant ' ... MyFunction = someArray End Function varV = MyFunction(anArray)() ' Illegal. varV = MyFunction(anArray) ' Legal. Returns the contents ' of the array. varV = MyFunction(anArray)(1) ' Legal. Returns the first element ' of the array. - You included empty parentheses in a reference to a class member
function that returns an array, list, or collection.
You can either remove the empty parentheses or insert the appropriate subscript or subscripts.