+ Reply to Thread
Results 1 to 1 of 1

VBA Pivot Table: Problem with pivot item visibility

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    1

    Angry VBA Pivot Table: Problem with pivot item visibility

    I am working on a pivot table in VBA. I have a working code for creating the pivot table and filling in the fields. What I would like to do now is to filter the data by dates. In the report filter, I am trying to select specific dates that precede a user inputted date.

    Say I have a list of the following dates:
    25/4/2013
    28/4/2013
    2/5/2013
    3/5/2013
    5/5/2013
    The user inputs for example 1/5/2013. The pivot table should then only display the data that corresponds to the dates before this (25/4/2013 and 28/4/2013).

    I wrote the code for this as well, but there are two issues I am now facing:

    1. When the date inputted by the user precedes the earliest date in filter field, Excel will select the last pivot item, rather than not selecting anything.
    2. While the code works on some computers, it doesn't work on others. In this case, the dates selected and not selected are more random.

    Below is the code:

    Please Login or Register  to view this content.
    Any help is appreciated!
    Last edited by arlu1201; 05-22-2013 at 04:16 AM. Reason: Use code tags in future.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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