Setting various column widths

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimbob - 31 Mar 2008 14:06 GMT

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

Reply to this Message

Klatuu - 31 Mar 2008 15:29 GMT

You should post your question in an Excel newsgroup. This group is for
Access, the Microsoft database application.

Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 9 lines]
> Thanks in advance
> Jim Parker

Reply to this Message