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