+ Reply to Thread
Results 1 to 2 of 2

Filter Pivot based on macro entry....

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Holliston, MA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Filter Pivot based on macro entry....

    I have a pivot table I want to filter based upon the value supplied by the user. I tried to create a macro to do this, but keep getting a "1004" error which states 'application-defined or object-defined error'. When I look at the variable, it is holding the value, but it can't be used for some reason.

    Please Login or Register  to view this content.

    Any ideas?
    Last edited by VBA Noob; 02-12-2009 at 03:17 PM.

  2. #2
    Registered User
    Join Date
    02-11-2009
    Location
    Holliston, MA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Filter Pivot based on macro entry....

    Basically I have a totals sheet which is based on numerous pivot tables. I want an easy way for users to change the filter without having to go into each pivot.

    If the macro idea isn't a good one, does anyone have a different idea?

    I'm sorry to bump, but I've looked everywhere and can't seem to find an answer. I have noticed a few other people in other forums asking the same question without any luck either.

    Thanks in advance for any help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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