How would I pass an array into a function like any other data type?
When I try:

private sub ProcessArray(MyArray as Array)
dim i%
for i = 0 to UBound(MyArray)
MyArray(i) = i
next
end sub

I get an error because the compiler is expecting values after the keyword "Array".

I tried this as a variant like:

private sub ProcessArray(MyArray as variant)
dim i%
for i = 0 to UBound(MyArray)
MyArray(i) = i
next
end sub

But during runtime I error out on the UBound(MyArray) call because of an invalid type argument. It appears that when I pass the original array in which is an array of strings, the variant type in the function is assumed to be just a string value and not an array of strings.

Can anyone help me please? Thanks.