Hi everyone
I have a VBA question that I thought was easy but I'm so missing something somewhere.
basically I have 2 sheets in a workbook
On Sheet2, I have a cell lets say is A1 with a calculated value lets say it contains the value "America"
On Sheet1 I have a pivot table controlled by a slicer called "Slicer_Country"
All I want to do is say set the slicer selection to whatever is in Sheet2 Cell A1
How do I do this?
I have a VBA question that I thought was easy but I'm so missing something somewhere.
basically I have 2 sheets in a workbook
On Sheet2, I have a cell lets say is A1 with a calculated value lets say it contains the value "America"
On Sheet1 I have a pivot table controlled by a slicer called "Slicer_Country"
All I want to do is say set the slicer selection to whatever is in Sheet2 Cell A1
How do I do this?
