How to vba pivot table to deselect items but sometimes one item may not be there

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to vba pivot table to deselect items but sometimes one item may not be there

FAQ

Thread Tools

Display Modes

04-22-2016, 05:34 AM

mbesspiata3 mbesspiata3 is offline

Windows 7 32bit How to vba pivot table to deselect items but sometimes one item may not be there

Office 2010 32bit

Novice

Join Date: Apr 2016

Posts: 5

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 PM.