Select Slicer Value based on range of cell values

Hi All,

I have a range of cell values which I need to select 1 after another in the slicer and call a function after the slicer item is selected.

I have tried to code it but get an error.

Please Login or Register  to view this content.

Help with suggestions on achieving this. Thanks in advance.

please try this code

Please Login or Register  to view this content.

Thanks wk9128, I tried the code but for each loop it is selecting all the slicer items in the first loop and next for each loop reducing 1 ex.

Loop 1 -> 25 items,
Loop 2> 24 items etc, but not the cell. value from the range