| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change column width
To change the column width of column "A", the following code
will work: Columns("A:A").ColumnWidth = 1.57 Is it possible to reference each column with a numerical index? Rather than using "A:A"? I was hoping that the following code would work, but it doesn't: Columns(1,1).ColumnWidth = 1.57 ' wrong |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why can't i change column width? | Excel Discussion (Misc queries) | |||
| Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
| Change the column width | Excel Discussion (Misc queries) | |||
| change column width | Excel Discussion (Misc queries) | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
![Robert Crandal[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
