|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to vba pivot table to deselect items but sometimes one item may not be there
I run a report to show inventory at various locations. I create the pivot table and deselect those items I don't want to show up but sometimes one vendor may not be in the inventory and this causes the vba to stop.
How can I still do this but have the vba not stop when it can't find the vendor I want to deselect? Help Mike |
#2
|
||||
|
||||
Hi
without seeing the macro and the data ( sheet) it will be difficult to help.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Include and Exclude items through vba in pivot table | mbesspiata | Excel Programming | 0 | 02-22-2016 12:30 PM |
Selecting/deselecting items in pivot table | mbesspiata | Excel | 0 | 07-22-2014 08:15 AM |
VBA Pivot Table CubeField Enable multiple items | Wries | Excel Programming | 0 | 03-13-2014 09:56 AM |
Pivot table - I cant display item labels when no fields in value area | differentdrummer | Excel | 0 | 12-12-2013 05:13 PM |