+ Reply to Thread
Results 1 to 3 of 3

How to add more then one XlPivotFilterType Enumeration in a macro for the same filed

  1. #1
    Forum Contributor MGadAllah's Avatar
    Join Date
    04-13-2008
    Location
    Sheet1
    MS-Off Ver
    365,2307,16.0.16626.20170,64bit
    Posts
    190

    How to add more then one XlPivotFilterType Enumeration in a macro for the same filed

    I am trying to use the XlPivotFilterType Enumeration in a macro according to this page in the Microsoft MSN website
    https://msdn.microsoft.com/en-us/vba...meration-excel
    This is the macro I am using
    Please Login or Register  to view this content.
    I want to add another month, how to do it? like Feb or Mar or both Feb and Mar, so the end result to be Jan, Feb, Mar ...etc
    These are the items for the whole year
    xlAllDatesInPeriodJanuary, xlAllDatesInPeriodFebruary, xlAllDatesInPeriodMarch , xlAllDatesInPeriodApril, xlAllDatesInPeriodMay, xlAllDatesInPeriodJune , xlAllDatesInPeriodJuly, xlAllDatesInPeriodAugust, xlAllDatesInPeriodSeptember, xlAllDatesInPeriodOctober, xlAllDatesInPeriodNovember, xlAllDatesInPeriodDecember
    Thanks

  2. #2
    Forum Contributor MGadAllah's Avatar
    Join Date
    04-13-2008
    Location
    Sheet1
    MS-Off Ver
    365,2307,16.0.16626.20170,64bit
    Posts
    190

    Re: How to add more then one XlPivotFilterType Enumeration in a macro for the same filed

    Any updates yet!?

  3. #3
    Forum Contributor MGadAllah's Avatar
    Join Date
    04-13-2008
    Location
    Sheet1
    MS-Off Ver
    365,2307,16.0.16626.20170,64bit
    Posts
    190

    Re: How to add more then one XlPivotFilterType Enumeration in a macro for the same filed

    any hope that any one may help as I can not solve this issue yet.

+ 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. Auto Selection of Pivot Filed Macro Reqd
    By santhu.g2007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 07:48 AM
  2. Need help for more advanced enumeration
    By bittersweets in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-15-2013, 06:04 AM
  3. [SOLVED] How to make excel last based on enumeration
    By eeman82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2013, 04:38 AM
  4. Enumeration of rows based on given counts
    By nilsonj in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-29-2013, 06:40 AM
  5. Data Concatenation and Conditional Enumeration
    By infohaard22 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2012, 02:20 AM
  6. opening macro filed workbook from Word
    By boomshank in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2010, 06:41 AM
  7. Rows Not Visible: Enumeration Skips
    By jefftanner in forum Excel General
    Replies: 2
    Last Post: 10-08-2008, 05:31 PM
  8. VSTO Cell Alignment Enumeration
    By Bob Sullentrup in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2005, 03:05 PM

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