Excel Macro to remove all row fields in a Pivot

[largeselection]

Hello,

Is this possible? I know how to do it if I'm trying to remove specific row fields by name, but is it possible to have a macro just remove all row fields regardless of name?

Thanks!

 

[largeselection]

SOLVED - Re: Excel Macro to remove all row fields in a Pivot

I figured it out- Thanks.

 

[BenSydney]

Re: SOLVED - Re: Excel Macro to remove all row fields in a Pivot

I figured it out- Thanks.

Can I ask how you figured it out please?? :D