Information générale
Titre:
Is there a way to pass an array into a function or Sub?
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement