Pivot table - show detail
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
|