That's it! Thanks a lot

--
/Enrico


"keepITcool" wrote:



have you tried GetPivotDATA worksheet function?




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Enrico Campidoglio wrote :

Hi

I am trying to find a way to programmatically read the sub-total
values from the data field of a pivot table. The problem is that i
don't seem to be able to access the single pivot items in the Data
Field. I read a KB article describing this as a problem in MS Excel's
object model
(http://support.microsoft.com/default...en-us;Q213455).
Anyway the suggested workaround doesn't work as even when accessing
the fields from the'VisibleFields' property of the pivot table object
instead of 'DataFields' I get exactly the same field objects among
which the one generated by the aggregate function 'Count of..', which
contains no pivot items.

Is there another way to read the values of the generated sub totals
in a pivot table or am i doing something wrong?