Dokat
asked on
Compile Error: Expected List Separator or) error message
I am receiving "Compile Error: Expected List Separator or)" error message. Can anyone help me with whats causing the error message with the below code.
Only change i made was in the last bracket i replaced "Delta" with "Range("AO294").Text"
Sub MyPvt() ' ' MyPvt Macro '
' ActiveSheet.PivotTables("M yPvt").Piv otFields( _ "[Append1].[Manufacturer]. [Manufactu rer]").Vis ibleItemsL ist = Array( _ "[Append1].[Manufacturer]. &[Range("A O294").Tex t]"
End Sub
Thank you
Only change i made was in the last bracket i replaced "Delta" with "Range("AO294").Text"
Sub MyPvt() ' ' MyPvt Macro '
' ActiveSheet.PivotTables("M
End Sub
Thank you
You are missing a closing ) at the very end of the line.
ASKER
I added the closing ) now I don't get error message but it doesn't update my filter selection when I ran the macro. Can you please help
Thanks
Thanks
Of course you removed the ' in front of the line?
ASKER
where do i need to put the ' in front of the line?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.