+ Reply to Thread
Results 1 to 2 of 2

Modification of a code that Prints all Pivot Filters

  1. #1
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Modification of a code that Prints all Pivot Filters

    Dear Experts,

    I have a report sheet which has 6 pivot tables (actually 2 but one of them shows 5 different views). All pivot tables are linked and with change in unique pivot table (PivotTable2) remaining 5 pivots also change to show the same pivot filter. Works fine till here.

    What I am trying to achieve is printing all pivot filter items of PivotTable2. I found the code below on Microsoft.com by Audrey-4340 but it is giving me runtime error 5 on line “ .CurrentPage = Pi.Caption”

    Please advise.
    Original Code:
    Please Login or Register  to view this content.
    My Modifications
    Please Login or Register  to view this content.
    Last edited by VKS; 02-28-2015 at 12:25 AM. Reason: Adding code tag on second code

  2. #2
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Modification of a code that Prints all Pivot Filters

    Hello Experts, Any Idea for me please!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Filters to change simulataneously with other pivot filters
    By ScottBeatty in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-02-2014, 10:48 AM
  2. [SOLVED] Add Pivot Table Filters to current UserForm code.
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2014, 06:30 PM
  3. Replies: 1
    Last Post: 02-22-2012, 12:21 PM
  4. VBA Code - Changing filters of several pivot tables based on cell values
    By kriskrispies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2010, 08:49 PM
  5. a loop formula that filters and prints?
    By scrabtree23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2005, 02:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1