Problem writing a macro to Hide Detail in a Pivot Table

B

Boop914

I have a pivot table with a row I want to Hide Detail for. I recorded
macro by clicking on the row heading I want to hide, then right clickin
and selecting Group and Outline and then selecting Hide Detail. Thi
all worked during recording, but when I try to play it back I get
Run-time error 1004; Unable to set the ShowDetail property of the Rang
class.

The recorded macro is:
Sheets("Classic").Select
Range("E7).Select
Selection.ShowDetail = False

Range E7 is the Row label of the data I want to hide.

I've recorded many macros and understand a lot of the quirks abou
pivot tables, but this one has me stumped. Any help is appreciated
 
Top