Solved

Compile Error: Expected List Separator or) error message

Posted on 2016-11-06
5
37 Views
Last Modified: 2016-11-21
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
Comment
Question by:Dokat
  • 3
  • 2
5 Comments
 
LVL 68

Expert Comment

by:Qlemo
ID: 41876422
You are missing a closing ) at the very end of the line.
0
 

Author Comment

by:Dokat
ID: 41876430
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
 
LVL 68

Expert Comment

by:Qlemo
ID: 41876968
Of course you removed the ' in front of the line?
0
 

Author Comment

by:Dokat
ID: 41877315
where do i need to put the ' in front of the line?
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 total points
ID: 41877581
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now