Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot Select Problem

Status
Not open for further replies.

Igwiz

Technical User
Jun 3, 2003
88
CA
Hi all,
I have a pivottable like this


Class Code %ofColumn SumofMV
----- ----
Fruit Apple 10 100
Pear 10 100
Banana 40 400
Veggie Broccoli 30 300
Courgette 10 100

I have written some code with a pivotselect command that reads:

ActiveSheet.PivotTables("PT-Food Table").PivotSelect _
"Class[Fruit]Code[ALL]", xlDataandLabel

and was hoping it return all the fruit data including the Labels. But unfortunately, this only seems to select the data. When I break the code and have a look at the table, the data is blue and copied but the labels are grey. Any ideas?

Many thanks,

IG
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top