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 vote312 views2 answers
Do until loop vba
VBA
4 votes311 views2 answers
Excel vba last column with data
VBA
27 votes454 views2 answers
Vba check if file exists
VBA
0 vote285 views1 answer
Excel vba populate array with cell values
VBA
5 votes343 views1 answer
Excel vba right word from Long Integer
VBA
0 vote352 views1 answer
Visual basic run command
VBA
0 vote316 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote340 views1 answer
Excel vba first column in range
VBA
0 vote310 views1 answer
Excel vba join variant array
VBA
0 vote311 views1 answer
Vba check if class implements interface
VBA