Function Fix Ups Class

ArgumentsToVariant

Places each of the arguments into an element of a Variant array, then returns that array inside a variant.

Signature (Visual Basic / VBA)

Public Function ArgumentsToVariant( _
    ParamArray vArgs() As Variant _
    ) As Variant

Code Example

    Assuming
       Dim varArray As Variant
    for example
       varArray = ArgumentsToVariant(12, 34, 56, "Word")
    leaves
       LBound(varArray) = 0
       UBound(varArray) = 3
       varArray(0) = 12
       varArray(1) = 34
       varArray(2) = 56
       varArray(3) = "Word"

Parameters

Parameter Description
vArgs One or values of any type. Each of the arguments will become one of the elements of an array that is returned by the function.