Passing multiple arguments with VBA?

Question

My VBA doesn't work with more than the first parameter. Here is my sub header: Sub filterPivotTables(ParamArray argumentsArray() As Variant , sheetName As String,pivotTableName As String,pivotField As String)

However, when I change the sub header to this: Sub filterPivotTables(ParamArray argumentsArray() As Variant) it works.

Is there a reason why I can’t pass in more than one parameter? How would you pass in more than one parameter? Thanks

How/Why doesn't it work?

Samuel Everson
– Samuel Everson

2020-06-02 01:07:30 +00:00
Commented Jun 2, 2020 at 1:07 — Samuel Everson
– Samuel Everson, Commented Jun 2, 2020 at 1:07

BigBen · Accepted Answer · 2020-06-02 01:10:04Z

2

ParamArray must be the last argument in the procedure declaration:

Sub filterPivotTables(sheetName As String, pivotTableName As String, pivotField As String, ParamArray argumentsArray() As Variant)

See the docs for a more thorough discussion of ParamArray.

answered Jun 2, 2020 at 1:10

BigBen

50.4k7 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Passing multiple arguments with VBA?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related