Pivot Item selection error

you set DBM but dim dbmitm

where is dbmitm value coming from then?

also if you clear filters and only make 1 visible...well then...all items are still visible

if you want only one item to be visible you need to make every other item not visible

i see your profile says 2013...if your only wanting one item from one pivot
you may be better off using pivotfield/pagefield
http://www.thespreadsheetguru.com/bl...l-pivot-tables
see section Report Filter On A Single Item

however if you still want to use pivot items
see section Report Filter On Multiple Items of the website

if you want to learn how to loop the pivot items instead of setting one by one
see post #2 on this thread to see how to i use set Pivot items syntax
its pretty similar to what your asking however i am doing multiple pivot tables with one cell
http://www.excelforum.com/excel-prog...ot-tables.html

not a problem
after taking in the information i have given and putting it into practice if you still having issues please come back and let me know what they are ill see if i can still help
otherwise if that takes care of the original question

please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.