Multiple Parameters for VBA doesn't work?

Help Studio
1

I am getting a Macro not found Error when I have more than this one 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

2

ParamArray has to be the last arguemnt

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.