Pivot Page Items!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, yes me again!! I have 15 sheets, each with a pivot table on. I have a
piece of code that allows a user to select a page item from a menu and the
code runs around and sets the page item. However, if the item doesn't exist
in one of the pivots it gives me an error message even though I have an error
hander? Am I missing something here? (well obviously I am!!). Any help
would be much appreciated.
 
have your code check what items it does have in that field before you try to
set it to something the field does not have.
 
Back
Top