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 vote235 views1 answer
Vlookup columns not next to each other
VBA
0 vote230 views1 answer
Vba nested dictionary
VBA
0 vote245 views1 answer
Convert unix to date vba
VBA
0 vote269 views1 answer
Vba DisplayGridlines
VBA
1 vote222 views2 answers
Get all column names from excel vba
VBA
3 votes250 views1 answer
Vba http request json
VBA
0 vote234 views1 answer
Vba check 32 or 64 bit
VBA
3 votes245 views1 answer
Extract the nth word from a text string
VBA
0 vote242 views1 answer
Excel delete ever other vba
VBA
0 vote228 views1 answer
Vbnet hex to binary
VBA