Changing a pivot table with a cell value

Hello all,

What I am trying to do is select a value in a named cell range called “DataSelection” to change the data field called” Name” within a Pivot Table called” PivotTable1”. I have been trying to get this code to work but I keep getting a run-time error ‘1004’ Method ‘Intersect’ of object ‘_Global’ failed. Whenever I try to select another data validation list I have on the worksheet, that has no relationship to PivotTable1.
Here is the code:

Please Login or Register  to view this content.

Thanks

Can you outline how "DataSelection" is defined ?

Better yet, post a small sample that demonstrates the issue.

You could perhaps first validate the Sh to the parent of the Name

Please Login or Register  to view this content.