VBA code to set pivot table row field in "next available" spot

Good morning!
I have a spreadsheet with a pivot table that has the row fields and page fields controlled by macro buttons. I would like to add an additional button for one of the fields to be placed in the last row field regardless of what is currently there.

Example: One possible row combination based on the macro buttons is to have the row fields SE, SD, SR another would be to have FC, FD, SR, SRG. Now to either of these I would like the user to have the option to add the field PG as the last row field. With the first example that would be in position 4, in the second example it would be position 5.

Is there code that would allow me to define the position as the "last" row field?

Please let me know if you need better definition of the issue. As always, your help is so greatly appreciated!

N

Good morning!
I have figured out how to do what I need - just don't specify the position and it automatically goes to the last position!

Please Login or Register  to view this content.

N