-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
getselectedsliceritems
-
Public Function seems to be slowing down all my subs
Thought it was my imagination... but... I have two public functions that I've defined which appear to be running as part of EVERY sub, regardless of if they are needed or not. [The public functions are called from my pivot table pages and are supposed to report back on which slicer items were...- CatyH
- Thread
- end function getselectedsliceritems public slicer
- Replies: 4
- Forum: Excel Questions
-
U
Slicer Data Extraction, Public Function
Hi Guys, Re Slicer Data Extraction I use the below Public Function, followed by the formula "=GetSelectedSlicerItems([@Description])". This works exactly as required, however every time I run other Macros, it loops through the Public Function constantly, slowing the Macro down. A; Is there an...- umplebyuk
- Thread
- function getselectedsliceritems public public function slicer extraction
- Replies: 1
- Forum: Excel Questions
-
P
Function to Capture Pivot Table Slicer Selection
All, I've tried this code I found, but all it ever returns is the last error message that the slice name doesn't exist. Here is the code: Public Function GetSelectedSlicerItems(SNme As String) As String Dim oSCache As SlicerCache Dim oSItem As SlicerItem Dim lCnt As Long...- pwyller
- Thread
- dim end function getselectedsliceritems oscache
- Replies: 0
- Forum: Excel Questions
