You need to use ByRef to pass arrays. For example, if I've got a function in a standard module that needs a string array as an argument I would declare the function like this:
<pre>
Private Function MyArrayFunction(ByRef sArray() as String)
'...
End Function</pre>
If this Function is on a UserForm or Class Module and you wanted to call them from outside of that module you woud have to declare the function like this:
<pre>
Public Function MyArrayFunction(ByRef sArray() as String)
'...
End Function</pre>
HTH