vba code...... on update...........
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
|