View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sharon Sharon is offline
external usenet poster
 
Posts: 183
Default Pivot Page Items!

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.
--
Sharon