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

4 votes128 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote157 views2 answers
VB
VBA
0 vote125 views1 answer
Vbs write file
VBA
0 vote130 views1 answer
Dlete rows with blanks and space " " vba
VBA
1 vote118 views2 answers
Vba find last row in range for certain criteria
VBA
2 votes128 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote128 views1 answer
Vba dictionary length
VBA
2 votes133 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote116 views1 answer
Vba like with wildcard
VBA
0 vote120 views1 answer
VB Error Code BC30201
VBA