View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wolfie Wolfie is offline
external usenet poster
 
Posts: 8
Default 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