Set cache = ActiveWorkbook.SlicerCaches("Slicer_BusinessDivision")ĭebug.Print cache.OLAP = True '//this is trueĭebug.Print īut Intellisense does not show anything else beyond ". Which contains the SlicerItems collection, but not sure how I can access this.
After that, select any of the cells from the table and then go to Insert Tab Slicer (click on the slicer button). First of all, press CTRL+T to convert the data (DOWNLOAD) into an Excel table, or you can also go to the Insert tab and click on the table. "Use the SlicerCacheLevels collection of the parent SlicerCache object to access the SlicerCacheLevel objects that represent these hierarchy levels." To insert a SLICER in an Excel Table use the following steps. I have been looking at the MS documentation and I don't know what I am doing wrong.Īfter making adjustment based on BigBen and Tim's comment, I looked at the documentation, which said: Interesting, when I Dim the object variable as above, Excel turn As SlicerItem to the lower case As slicerItem. Which is what I specified and also Intellisense showed it as well. (2) I want to list out all the Slicer items using the below code, in this case also got the '1004' error: Dim oSlicerItem As slicerItemįor Each oSlicerItem In ActiveWorkbook.SlicerCaches("Slicer_BusinessDivision").SlicerItemsĪccording to the MS documentation, SlicerItems property is contained in a SlicerCache object in: Run-time error '1004' Application-defined or object-defined error: Debug.Print ActiveWorkbook.SlicerCaches("Slicer_BusinessDivision").unt In my test code, all I wanted to do are (1) Get a count of the Slicer items in the Slicer, but I got a I have a number of Slicers in an Excel workbook file.
0 kommentar(er)
