Okay... so I've tried this many different ways, including replacing the word 'Columns' with 'Range', and adding zeros after the whole numbers, but the following code when run only works for columns A and B, then all the rest go to 1.71........ Any suggestions? Is there a two-column limit to macros??
Thanks!!
Range("A:A").Select Selection.ColumnWidth = 4.29 Range("B:B").Select Selection.ColumnWidth = 2.86 Range("C:C").Select Selection.ColumnWidth = 13# Range("D:D").Select Selection.ColumnWidth = 2.86 Range("E:E").Select Selection.ColumnWidth = 1.71 Range("F:F").Select Selection.ColumnWidth = 12.71 Range("G:G").Select Selection.ColumnWidth = 2.86 Range("H:H").Select Selection.ColumnWidth = 1.71 Range("I:I").Select Selection.ColumnWidth = 13.14 Range("J:J").Select Selection.ColumnWidth = 2.14 Range("K:K").Select Selection.ColumnWidth = 1.71 Range("L:L").Select Selection.ColumnWidth = 13# Range("M:M").Select Selection.ColumnWidth = 2.14 Range("N:N").Select Selection.ColumnWidth = 1.71 Range("O:O").Select Selection.ColumnWidth = 12.86 Range("P:P").Select Selection.ColumnWidth = 2.14 Range("Q:Q").Select Selection.ColumnWidth = 1.57 Range("R:R").Select Selection.ColumnWidth = 11# Range("S:S").Select Selection.ColumnWidth = 2.14 Range("T:T").Select Selection.ColumnWidth = 1.57
Bookmarks