Hello everyone,
I have an excel file with a slicer in an excel sheet, and am trying to extract the value of the item that is selected in the slicer. What I'm trying to achieve is that you select an item in the slicer, and on a different sheet the value of that selected item is displayed in a certain cell. I've been able so far to display the name of the slicer, or the 1st value in the slicer, but never the selected value. This is what I'm using:
Please Login or Register to view this content.
If I try to get the name of the slicer, it works fine like this:I was expecting the ActiveItem would work the same way, but I cant seem to figure out why it won't work.Please Login or Register to view this content.
I keep getting this error: Application-defined or object-defined error.
Anyone have an idea what I'm doing wrong?
Thanks in advance!
Bookmarks