Pivot table - show detail

  • Thread starter Thread starter Wolfie
  • Start date Start date
W

Wolfie

I'm trying to create a procedure to show the detail in a pivot table. Using
the macro recorder, I get:

Range("B7").Select
Selection.ShowDetail = True

However, I'd prefer to reference the pivot field (field name = Division)
directly.

TIA,

Dave
 
Dim pvtitm as PivotItem
for each pvtitm in
activesheet.PivotTables(1).PivotFields("Division").PivotItems
pvtitm.ShowDetail = True
Next
 
Thanks Tom!

Tom Ogilvy said:
Dim pvtitm as PivotItem
for each pvtitm in
activesheet.PivotTables(1).PivotFields("Division").PivotItems
pvtitm.ShowDetail = True
Next
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop a simple macro 1
VB Help If Statement in Selection.ShowDetail = True 5
ShowDetail on PivotTable does not work in VBA 0
select pivot table range 1
Pivot table multiple filters 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Create Detail Sheets from Pivot Table 1
Skip over a particular error 2

Back
Top