• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

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("MyPvt").PivotFields( _ "[Append1].[Manufacturer].[Manufacturer]").VisibleItemsList = Array( _ "[Append1].[Manufacturer].&[Range("AO294").Text]"

End Sub

Thank you
0
Dokat
Asked:
Dokat
  • 3
  • 2
1 Solution
 
QlemoC++ DeveloperCommented:
You are missing a closing ) at the very end of the line.
0
 
DokatAuthor Commented:
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
0
 
QlemoC++ DeveloperCommented:
Of course you removed the ' in front of the line?
0
 
DokatAuthor Commented:
where do i need to put the ' in front of the line?
0
 
QlemoC++ DeveloperCommented:
Sub MyPvt() ' ' MyPvt Macro '

ActiveSheet.PivotTables("MyPvt").PivotFields( _ "[Append1].[Manufacturer].[Manufacturer]").VisibleItemsList = Array( _ "[Append1].[Manufacturer].&[Range("AO294").Text]")

End Sub

Open in new window

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now