Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ChadElzinga
- Order by date
-
Unable to set PivotItem.Visible
Sorry, I was trying to get rid of some of my naming conventions to simplify the reading of the code. I switched from a While loop to a For loop when I was writing the post because I wasn't familiar with VB sytax when I first wrote the macro. I forgot to take out the line where I increment the...- ChadElzinga
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Unable to set PivotItem.Visible
I've written a little script to restrict the PivotItems that are visible for a specific PivotField by iterating through the pivot items and setting their visibility to false if they don't fall within a user specified range. The code currently looks something like this...- ChadElzinga
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Deleting Range Names in Excel, Pivot table values
I've fount it! I've been struggling with this problem all day, and I've found that you can set the PivotCache.MissingItemsLimit to 0 and that will get rid of all the old values in the PivotField objects. Whew! That's a load off. The old values were causing one of my macros to crash. Hope you...- ChadElzinga
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
