How to create a VBA function with Several argument as ParamArray or equivalent

Question

I would like to create a VBA Function where I can enter as argument several array, in order to perform matrix calculation on them, like the Excel function MMULT for example.

Answer 1

Here is an example. Armed with this and the help file you should be able to figure it out.

'PROCEDURE:
'   MaxValue
'PURPOSE:
'   Using variants because user can pass in any data type.
'   Example: myMax = MaxValue(1, 3.5, 5)
'ARGUMENTS:
'   Any number of values (not an array)
'RETURNS:
'   Variant
Public Function MaxValue(ParamArray varValue() As Variant) As Variant
    Dim v                   As Variant
    Dim vMax                As Variant

    If UBound(varValue) = -1 Then
        vMax = Null        'Zero arguments passed in
    Else
        vMax = varValue(0)
        For Each v In varValue
            If v > vMax Then vMax = v
        Next
    End If
    MaxValue = vMax
End Function

Answer 2

Thank, it is not what I was especting but finally I find my answer:

Function ReturnMMult(Arr1rng As Range, Arr2rng As Range) As Variant

Dim Arr1() As Variant: Arr1 = Arr1rng.Value
Dim Arr2() As Variant: Arr2 = Arr2rng.Value
ReturnMMult = WorksheetFunction.MMult(Arr1, Arr2)

End Function