| 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 | |||
![Jesse[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
