| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to change column widths?
I am running code to open a workbook and then I want to set all columns in
the workbook to 15. I use: ..Workbooks.Open "C:\Shared\Report Info.xlsx" ..Columns.ColumnWidth = 15 This code only works on the first sheet in the workbook, but I need it to work for all sheets. Can someone please help me? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column widths change with each new import from Access 2007 | New Users to Excel | |||
| Automatically change column widths? | Excel Discussion (Misc queries) | |||
| Why do column widths change in Excell? | Excel Worksheet Functions | |||
| Need to change column widths in middle of page. | Excel Discussion (Misc queries) | |||
| Excel column widths change on different machines | Excel Programming | |||
Threaded Mode
