Ordering 3 data columns

T

Travassos

Hello

I have a pivot table with 3 data columns that must appear in this
order : a,b,c. Suppose i delete column b . When the program reinsert
the column it appears at the end : a,c,b. Is there a way to reorder
this columns without deleting them all and reinserting with at the
pretended order ? I have some urgent in this so a sample code with be
a great help :)


thanks is advance

mt
 
J

jankrib

Hello

I have a pivot table with 3 data columns that must appear in this
order : a,b,c. Suppose i delete column b . When the program reinsert
the column it appears at the end : a,c,b. Is there a way to reorder
this columns without deleting them all and reinserting with at the
pretended order ? I have some urgent in this so a sample code with be
a great help :)

thanks is advance

mt
Click to expand...

You could use the optional before parameter in InsertFieldSet.
In your example it would be:

ColumnAxis.InsertFieldSet(b,c)

Jan
 
Top