OK, not quite sure what you are saying, so let me see if this helps.
Passing Arrays as Parameters
1. Reference the array by name in the CALL statement
2. The called SUB/FUNCTION MUST accept the data into a parameter declared with the SAME data type, but without an index.
3. Arrays must be passed using the ByRef Method.
Ex.
Public Sub ProcTest(By Ref lngNum() as Long)
lngNum(1) = 2
End Sub
Public Sub Something()
Dim lngArray(1 To 5) as Long
Call ProcTest(lngArray)
MsgBox("Index 1 = " & lngArray(1))
End Sub
Hope this helps?! :lol: