Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change ColumnWidth for Multiple Columns?
I need to be able to change the column width on multiple columns (all
next to each other) on one sheet (i.e. codename: sheet10) based on user data selected from a combobox on sheet1. I have tried using this but it always fails, so I would really appreciate any help on fixing it: with sheet10 'codename for sheet .unprotect .columns(4,zColCount).columnwidth=dblColWidth ' col D thru # of columns entered .protect end with Thanks again....AJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columnwidth | Excel Discussion (Misc queries) | |||
Columns.ColumnWidth error...sometimes | Excel Programming | |||
ColumnWidth | Excel Programming | |||
Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
ColumnWidth | Excel Programming |