Vba multiple optional arguments

' Use a ParamArray
Sub Test(ByVal pArg As String, ParamArray pParameters() As Variant)
	' Can't be combined with 'Optional' arguments
    Dim sValues
    For Each sValues In pParameters
  Debug.print sValues
    Next  
End SUb

Similar codes

0 vote277 views1 answer
How to self delete a vbscript file
VBA
0 vote322 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote362 views1 answer
Vba foreach 2d array
VBA
1 vote321 views1 answer
Vbs run
VBA
0 vote322 views1 answer
Enable macros on opening workbook vba
VBA
0 vote336 views1 answer
Columns dont autoresize on program start vb.net
VBA
1 vote333 views1 answer
Set font for ms chart vb.net
VBA
0 vote330 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote312 views1 answer
Vbnet line graph smooth lines
VBA
1 vote311 views1 answer
Sort using vba
VBA