G
Guest
Hi Guys;
I have the code below working but I need to adjust the Column
Width for Each Column Seperately! Only my second time with Excel, so please
excuse my lack of experience!
With ws.Range("A:Q").EntireColumn
.ColumnWidth = 100
.AutoFit
End With
Example Column A = 25
Column B = 75
Column C = 14
etc.
How do I do this in Macro Code?
Thank You in Advance Group!
Nancy X
I have the code below working but I need to adjust the Column
Width for Each Column Seperately! Only my second time with Excel, so please
excuse my lack of experience!
With ws.Range("A:Q").EntireColumn
.ColumnWidth = 100
.AutoFit
End With
Example Column A = 25
Column B = 75
Column C = 14
etc.
How do I do this in Macro Code?
Thank You in Advance Group!
Nancy X