Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Pivot Items
Hi
I am facing a problem. I am getting the error 1004 "Unable to get data range property of the pivot item class". My pivot has 3 column fields (or rather pivot items) They are - First Box, Second Box, Third Box. First Box and Second Box. When the loop runs through First and Second Box, the program runs smoothly because they both contain data and are visible in the pivot. However when the loop gets to the Third Box which has no data and is not visible (it is clicked on the field drop down though) , I get the above error. This appears to be self deating as I am unable to understand what code to write that filters or ignores the Third Box so that I do not get this run time error. Please help as I am unable to proceed because of this. Thanks Manish |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
top items in a pivot by page | Excel Discussion (Misc queries) | |||
Pivot Table Items | Excel Discussion (Misc queries) | |||
Name items in Pivot Tables? | Excel Discussion (Misc queries) | |||
PROBLEM OF ADDING CALCULATED ITEMS TO PIVOT TABLE | Excel Discussion (Misc queries) | |||
Pivot Items | Excel Programming |