Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format all column width
Sub SetColumnWidth()
for each sh in activeworkbook.Worksheets sh.Columns.ColumnWidth = 8.43 Next end Sub -- Regards, Tom Ogilvy "Daniel" wrote: How can I write a macro so that it can format all column width equal to standard or exp=20 THe funtion if nice should apply for all sheets in a workbook? Thanks Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column width format | Excel Discussion (Misc queries) | |||
Format Painter Column Width | Excel Discussion (Misc queries) | |||
Excel - CSV Format and column width | Excel Discussion (Misc queries) | |||
Excel's column width format box | New Users to Excel |