VBA error VBA Exel Compile error: Expected: end of statement caused by (

[Kumar Shanmugam]

Hi please find attached the screenshot I am trying to make dynamic pivot table report filters. Pivot one both are name reference. One is of pivot filter value

 

[Kumar Shanmugam]

Image file attached

 

[Hui]

The structure of your line is totally wrong
No formulas or structures start with a (
which is why you have an error

Can you describe what you are trying to achieve?
Better still is to also attach a file so we can give you a more targeted response

 

[NARAYANK991]

Hi ,

If you mean named ranges , then the correct way to use them is to enclose them in square brackets , as in :

[Pivotzone]

Narayan

 

[Kumar Shanmugam]

Yes thanks its working