I have a pivot table (excel 2002) with several column fields. It looks like
this:
Category 1
Subcategory A Subcategory B
......

I would like to be extract data from one column, say Subcategory B,
programmatically. How can I do that?

I tried to use GetPivotData, but could not figure out how it works.

Thanks -

RADO