Ordering 3 data columns

[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

 

[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

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

ColumnAxis.InsertFieldSet(b,c)

Jan

 

[Travassos]

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

ColumnAxis.InsertFieldSet(b,c)

Jan

THANKS JAN !