Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way I can preset the column width(s) for all new
sheets created in a workbook? Below are the measurements I need. Columns("a:a").Select Selection.ColumnWidth = 5.43 Columns("b:b").ColumnWidth = 57.14 Columns("b:b").EntireColumn.AutoFit Columns("c:c").Select Selection.ColumnWidth = 6.29 Columns("d:d").Select Selection.ColumnWidth = 8.43 Columns("e:e").Select Selection.ColumnWidth = 12.43 Columns("f:f").Select Selection.ColumnWidth = 12.14 Columns("g:g").Select Selection.ColumnWidth = 14.14 Columns("h:h").Select Selection.ColumnWidth = 8 Columns("i:i").Select Selection.ColumnWidth = 18.57 Columns("j:j").Select Selection.ColumnWidth = 21.57 Columns("k:k").Select Selection.ColumnWidth = 4.71 Columns("l:l").Select Selection.ColumnWidth = 8.43 Thanx., |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto fit column width and row height | Excel Discussion (Misc queries) | |||
create a micro for Auto Column Width and put on tool bar | Excel Programming | |||
Auto Adjust the Width of a Column | Excel Programming | |||
Column Auto Width and Hidden Rows | Excel Discussion (Misc queries) | |||
Column character width on auto filter | Excel Discussion (Misc queries) |