[COLOR="#008080"]'The Maximum Limit for Required Arguments is 60[/COLOR]
Function MAX_ARGS_1( _
a001&, a002&, a003&, a004&, a005&, a006&, a007&, a008&, a009&, a010&, _
a011&, a012&, a013&, a014&, a015&, a016&, a017&, a018&, a019&, a020&, _
a021&, a022&, a023&, a024&, a025&, a026&, a027&, a028&, a029&, a030&, _
a031&, a032&, a033&, a034&, a035&, a036&, a037&, a038&, a039&, a040&, _
a041&, a042&, a043&, a044&, a045&, a046&, a047&, a048&, a049&, a050&, _
a051&, a052&, a053&, a054&, a055&, a056&, a057&, a058&, a059&, a060&) As Variant
MAX_ARGS_1 = a001 & "...." & a060
End Function
[COLOR="#008080"]'The Maximum Limit for a ParamArray Arguments is 254[/COLOR]
Function MAX_ARGS_2(ParamArray aMax() As Variant) As Variant
MAX_ARGS_2 = aMax(LBound(aMax)) & "...." & aMax(UBound(aMax))
End Function
[COLOR="#008080"]'The Maximum Limit for UDF Arguments is 255 (1 Required plus 254 in ParamArray)[/COLOR]
Function MAX_ARGS_3(aRequired&, ParamArray aMax() As Variant) As Variant
MAX_ARGS_3 = aRequired & ", " & aMax(LBound(aMax)) & "...." & aMax(UBound(aMax))
End Function