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: