+ Reply to Thread
Results 1 to 2 of 2

Macro to deselect certain items

  1. #1
    Forum Contributor
    Join Date
    09-05-2007
    Posts
    148

    Macro to deselect certain items

    I am creating a macro to automate something i currently do manually at work.

    I have insert data into a sheet and my macro needs to refresh the pivot and then copy and paste the data into another sheet and format it.

    This is all ok and working fine but now i need to de-select certain entries from the report filter section of the pivot.

    Problem is, those entries might not be there all the time, so how do you deselect something that isn't there? I'm guessing i need an if function in my macro to check of the entry is there but don't really know how to use it in this situation.

    Could someone please help me with this?


    Thanks

  2. #2
    Forum Contributor
    Join Date
    09-05-2007
    Posts
    148

    Re: Macro to deselect certain items

    Please, anyone?

+ 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