Slicer Items filter based on from and to cell value references (OLAP data)

[JAYA TEJA]

Hai
I need a small help in VBA coding
I need to filter Slicer Items based on 2 cell references (From and to)

Please share coding for sample attachment

It helps me a lot

Thanking you

 

[JAYA TEJA]

I am using OLAP database, I tried with below code, it was not working,
Can anyone help with this?

Sub Cliquer()
    Dim ar1
    Dim strConst As String
    strConst = "[Time].[Fiscal Day Of Year].&["
    ReDim ar1(1 To Cells(Rows.Count, "H").End(xlUp).Row - 1)
 
    For i = 1 To UBound(ar1)
        ar1(i) = strConst & Cells(i + 1, "H").Value2 & "]"
    Next
 
    ThisWorkbook.SlicerCaches("Slicer_Fiscal_Day_Of_Year").VisibleSlicerItemsList = ar1
End Sub

 

[JAYA TEJA]

I got it
It was working now.
Problem resolved...