Macro Alternate column width adjustment

[stct80]

Hello and Greetings!

I am relatively new to the VB/Macro coding. Can someone advise on how can I adjust width of pivot value - alternate columns using VB macro?

The pivot table has 2 data points under 'Values' and I want one of the columns to be of certain fixed width (2 characters) and the other ones to be of 10 characters. So every alternate column should be 2 and 10 characters respectively.

If I can set this in pivot, without VB Macro, that is fine too!

Best Regards,

stct80.

 

[stct80]

Actually, just found the solution in mrexcel forums, so pls ignore the post & Thank you!

stct80.....

Hello and Greetings!

I am relatively new to the VB/Macro coding. Can someone advise on how can I adjust width of pivot value - alternate columns using VB macro?

The pivot table has 2 data points under 'Values' and I want one of the columns to be of certain fixed width (2 characters) and the other ones to be of 10 characters. So every alternate column should be 2 and 10 characters respectively.

If I can set this in pivot, without VB Macro, that is fine too!

Best Regards,

stct80.