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

1 vote248 views1 answer
Vba refresh pivot table
VBA
0 vote246 views1 answer
Vba len variant
VBA
0 vote234 views1 answer
Xlbycolumns is not declared
VBA
4 votes248 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote268 views1 answer
Vba registry settings
VBA
0 vote260 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
1 vote241 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
1 vote274 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
5 votes251 views1 answer
Xlvba double quotes in string literal
VBA
0 vote247 views1 answer
Regex numeric digits
VBA