Setting various column widths

  • Thread starter Thread starter Jimbob
  • Start date Start date
J

Jimbob

I have 15 sheets in a workbook and I want to set the column widths
individually but all seem to be re-adjusted by the code I have recorded. Any
clues why this is so? Here is a sample of my code:

Columns("L:L").Select
Selection.ColumnWidth = 6
Columns("M:M").Select
Selection.ColumnWidth = 4
Columns("N:Q").Select
Selection.ColumnWidth = 35

Thanks in advance
Jim Parker
 
You should post your question in an Excel newsgroup. This group is for
Access, the Microsoft database application.
 
Back
Top