Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2014, 11:59 AM
galkej galkej is offline Excel Macro to "Select All" in Pivot Table Field Windows 8 Excel Macro to "Select All" in Pivot Table Field Office 2013
Novice
Excel Macro to "Select All" in Pivot Table Field
 
Join Date: Feb 2014
Posts: 3
galkej is on a distinguished road
Default Excel Macro to "Select All" in Pivot Table Field

I have the code below to "turn off" certain values of a field in a Pivot Table, but how do I accomplish this if I want to "turn on" all values in a field of a Pivot Table?

Thanks

Dim pi_2 As PivotItem


With ActiveSheet.PivotTables("PivotTable3").PivotFields ("Order")
For Each pi_2 In .PivotItems
If pi_2.Caption = "(blank)" And pi_2.Visible = True Then
pi_2.Visible = False
Exit For
End If
Next
End With
Dim pi_3 As PivotItem
With ActiveSheet.PivotTables("PivotTable3").PivotFields ("Order")
For Each pi_3 In .PivotItems
If pi_3.Caption = "#N/A" And pi_3.Visible = True Then
pi_3.Visible = False
Exit For
End If
Next
End With
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: "Changes made were lost...reconnect with server", when switching "from" field randhurrle Outlook 2 02-25-2015 06:51 PM
Excel Macro to "Select All" in Pivot Table Field Word options "field shading" reverts to "when selected" PaulBurcham Word 1 04-20-2013 11:18 AM
How to edit the "Format" and the "show level" of an EXISTING table of content? Jamal NUMAN Word 2 08-14-2011 10:46 AM
Excel Macro to "Select All" in Pivot Table Field "Table of content" based on "Normal Style" behavior!!!! Jamal NUMAN Word 4 07-08-2011 04:12 AM
Excel pivot table into an MS Word Doc "office 2007" wmarsh3561 Excel 1 01-09-2010 08:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft