Hello I've been searching for a few days now but without sucess.
So I've the following code to go throught all the Slicer Items:
Code
Public Sub SeleccionarFiltro()
Dim si As SlicerItem
'Limpiar el filtro
ActiveWorkbook.SlicerCaches("SegmentaciónDeDatos_Pedido").ClearManualFilter
'Comprobación si en el filtro hay el pedido selecionado
For Each si In ActiveWorkbook.SlicerCaches("SegmentaciónDeDatos_Pedido").SlicerItems
si.Selected = False
If si.Value = cbx_PEDIDO.Value Then
si.Selected = True
Else
si.Selected = False
End If
Next si
End SubI've a blank row ,on my table, so on my slicer there's a blank Item, what I really want is that If the slicer does not have the value of the combobox(cbx_PEDIDO) that unselect all Slicer Items but the blank slice, that the only one select is the blank one.
Any idea on how to do that?