A better way to place RowFields in a pivot

[jomili]

There's nothing WRONG, but I wonder if there's a better way. See my code at the bottom, for bringing 7 different fields in my RowFields. Would there be a way to do this with an array of the PivotField names and the count of those names, like (pseudocode):

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[YasserKhalil]

Try this (untested)

Please Login or Register  to view this content.

[jomili]

On the line below I'm getting the error "Unable to get the PivotFields property of the PivotTable class".

Please Login or Register  to view this content.

Whoops, my bad: the problem was "Project_ID" vs "ProjectID". Fixing that got your code running spot on. I KNEW there was a way to do it! Thanks so much for your help!

[YasserKhalil]

You're welcome. Glad I can offer some help.