Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivotitem count
Try as I might I can't get the count of items in a pivot field.
I tried Activesheet.PivotTables("BDStore").PivotField("Sto re").pivotitems.count But that returns object doesn't support this property or method. The pivotitems object does have a count property but I'm suspecting I'm not using it correctly. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivotitem count
try adding an "s" to PivotField --
ActiveSheet.PivotTables("BDStore").PivotFields("St ore").PivotItems.Count Jesse wrote: Try as I might I can't get the count of items in a pivot field. I tried Activesheet.PivotTables("BDStore").PivotField("Sto re").pivotitems.count But that returns object doesn't support this property or method. The pivotitems object does have a count property but I'm suspecting I'm not using it correctly. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivotitem count
Still fails with a run time 1004, count method failed.
Jesse "Debra Dalgleish" wrote in message ... try adding an "s" to PivotField -- ActiveSheet.PivotTables("BDStore").PivotFields("St ore").PivotItems.Count Jesse wrote: Try as I might I can't get the count of items in a pivot field. I tried Activesheet.PivotTables("BDStore").PivotField("Sto re").pivotitems.count But that returns object doesn't support this property or method. The pivotitems object does have a count property but I'm suspecting I'm not using it correctly. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivotitem count
I got it working, that with another error I had fixed it.
Pretty much a user problem <grin Jesse "Debra Dalgleish" wrote in message ... try adding an "s" to PivotField -- ActiveSheet.PivotTables("BDStore").PivotFields("St ore").PivotItems.Count Jesse wrote: Try as I might I can't get the count of items in a pivot field. I tried Activesheet.PivotTables("BDStore").PivotField("Sto re").pivotitems.count But that returns object doesn't support this property or method. The pivotitems object does have a count property but I'm suspecting I'm not using it correctly. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
VSTO - dynamic Hide/Unhide PivotItem OLAP. | New Users to Excel | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Debra's sample code to hide a Pivotitem | Excel Programming |