I am using VBA to create a pivot table. The issue is the total amount of columns changes depending on the data set I put through it. Is there any way to reference a header no matter where it is on the pivot table?
I am using VBA to create a pivot table. The issue is the total amount of columns changes depending on the data set I put through it. Is there any way to reference a header no matter where it is on the pivot table?