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
Bookmarks