+ Reply to Thread
Results 1 to 4 of 4

PivotFields | Select Pivotitem avoiding false

  1. #1
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    PivotFields | Select Pivotitem avoiding false

    Dears good morning,

    I would like to know if there is a way to avoid the following code repeating "False" and in case a new name is upcoming in the list, to avoid to update the list in the code with the new name.

    Actually my code is the following one :

    Please Login or Register  to view this content.
    What I am looking for is to avoid all these line repeat6ing "False".
    I am wondering if it is possible to create a code saying that : If the pivotitem is <> than "MyValue", then true for my value and false for the rest >

    I hope my message is clear enough to understand it.

    Waiting for feedback
    Regards

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: PivotFields | Select Pivotitem avoiding false

    Something like below?

    Please Login or Register  to view this content.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    06-01-2017
    Location
    Santos
    MS-Off Ver
    Office 2016 - Windows 7
    Posts
    105

    Re: PivotFields | Select Pivotitem avoiding false

    Yes, this is it !!!!

    Thank you CK76

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: PivotFields | Select Pivotitem avoiding false

    You are welcome and thanks for the rep.

+ 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. PivotItem loop with getpivotdata - hide pivotitem
    By csutera in forum Excel General
    Replies: 1
    Last Post: 01-14-2016, 10:41 AM
  2. Screen Updating = False not working - need help to remove .select from code?
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2014, 08:58 PM
  3. Replies: 0
    Last Post: 06-14-2013, 12:33 PM
  4. Select specific PivotItem
    By selopezr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2011, 09:25 AM
  5. Avoiding Range("A1").Select
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2011, 07:10 AM
  6. Replies: 0
    Last Post: 08-23-2005, 11:53 AM
  7. avoiding select
    By Ward Germonpré in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2005, 04:06 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