sc: SlicerCache
s: Slicer
We use this way
With sCache
.SlicerItems("1").Selected = True
.SlicerItems("2").Selected = False
.SlicerItems("3").Selected = True
End With
and not this way:
With s
.SlicerItems("1").Selected = True
.SlicerItems("2").Selected = False
.SlicerItems("3").Selected = True
End With
My understanding currently:
- a table column can have a slicer cashe object attached to it
- if I create another SlicerItem from same cache, then it will look the same
- and I can set item selection through the SlicerCache, and not through the Slicer object itself
Is this 3 lines correct? And if yes, what is the function of creating multiple Slicer from same cache? It will just give the same output, so making 1 Slicer from 1 cache is the most you can do. When would it be useful to make more slicers from same cache?
Thank you very much for your answer, I am really confused about this. Have a nice day.
s: Slicer
We use this way
With sCache
.SlicerItems("1").Selected = True
.SlicerItems("2").Selected = False
.SlicerItems("3").Selected = True
End With
and not this way:
With s
.SlicerItems("1").Selected = True
.SlicerItems("2").Selected = False
.SlicerItems("3").Selected = True
End With
My understanding currently:
- a table column can have a slicer cashe object attached to it
- if I create another SlicerItem from same cache, then it will look the same
- and I can set item selection through the SlicerCache, and not through the Slicer object itself
Is this 3 lines correct? And if yes, what is the function of creating multiple Slicer from same cache? It will just give the same output, so making 1 Slicer from 1 cache is the most you can do. When would it be useful to make more slicers from same cache?
Thank you very much for your answer, I am really confused about this. Have a nice day.