Posted to microsoft.public.excel.programming

Jesse[_4_] Jesse[_4_] is offline

external usenet poster

Posts: 15

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Employee Work Time - Don't Double-count Overlapping Apts.	J	Excel Worksheet Functions	0	April 27th 07 05:52 AM
Excel 2000, count, sort a list & count totals?	sunslight	Excel Worksheet Functions	1	April 9th 07 05:46 PM
VSTO - dynamic Hide/Unhide PivotItem OLAP.	zeric	New Users to Excel	0	January 31st 06 02:06 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Excel Worksheet Functions	9	July 31st 05 03:37 AM
Debra's sample code to hide a Pivotitem	Fred bon	Excel Programming	0	August 7th 03 02:48 AM

All times are GMT +1. The time now is 06:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us