VBA code to Expand all rows in a pivot table

**mbond007** · 10-26-2018, 09:18 AM

I want to add a control button on my worksheet that has a pivot table that will expand all rows. I keep getting this error message: Run-time error '1004'; Application-defined or object-defined error. Can anyone help me understand what I need to do to fix this error? Thanks

HTML Code:

**mbond007** · 10-26-2018, 09:20 AM

I forgot to mention that the error is pointing to the 'rf.ShowDetail = True' line.

VBA code to Expand all rows in a pivot table

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to Expand all rows in a pivot table

Re: VBA code to Expand all rows in a pivot table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adapting VBA code to alow use of expand/collapse field on a pivot table

[SOLVED] Pivot table-remove expand and close from pivot layout

VBA for Pivot Table (Expand All)

Use slicer to expand / collapse pivot table

Expand a table by adding rows ( table feature 2007 and later)

VBA To Expand Pivot Table and Copy Pivot Items

Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table

Bookmarks

Bookmarks

Posting Permissions