| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Page Items!
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. -- Regards, Tom Ogilvy "Sharon" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependent page items in pivot table | Excel Discussion (Misc queries) | |||
| Select multipul 'Page' items in a Pivot Table | Charts and Charting in Excel | |||
| top items in a pivot by page | Excel Discussion (Misc queries) | |||
| Pivot Table dropping items from page item list | Excel Discussion (Misc queries) | |||
| Stepping through Pivot table page field items with VBA | Excel Programming | |||
Linear Mode
