Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2016, 05:34 AM
mbesspiata3 mbesspiata3 is offline How to vba pivot table to deselect items but sometimes one item may not be there Windows 7 32bit How to vba pivot table to deselect items but sometimes one item may not be there Office 2010 32bit
Novice
How to vba pivot table to deselect items but sometimes one item may not be there
 
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
  #2  
Old 04-22-2016, 07:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to vba pivot table to deselect items but sometimes one item may not be there Windows 7 64bit How to vba pivot table to deselect items but sometimes one item may not be there Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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 08:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft