Thread: [Solved] How to vba pivot table to deselect items but sometimes one item may not be there
View Single Post
 
Old 04-22-2016, 05:34 AM
mbesspiata3 mbesspiata3 is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Apr 2016
Posts: 5
mbesspiata3 is on a distinguished road
Default 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
Reply With Quote