Hi,

I have a pivot table, and on selection i want it to format the width of the
columns. The problem i'm having is that i can only set the widths to all the
same. Im wanting column A & B wider than the rest. The code i have used so
far is

Range("C:Z").Select
Selection.ColumnWidth = 14
Range("A:B").Select
Selection.ColumnWidth = 31

but this some how sets all the coloumns to 31????????

Any help will be helpful as i am new to vba, thanks

Paul