I'm using the macro below to pull the detail from an existing pivot, and I'm having trouble right from the start. When the macro hits the "Get the Details" part, it performs the operation correctly, then displays a run-time 1004 error saying "Unable to set the ShowDetail property of the Range class", despite the fact that it just DID provide that detail. Any idea why it would generate an error AFTER it performs the operation and achieves the result? 
Please Login or Register  to view this content.