Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot set ColumnWidth past column 148
I have a spreadsheet with 198 columns built by VBA procedures. Columns 7 thru 198 contain monthly data, i.e., columns 7 thru 18 contain data for the months of year 1, columns 19 thru 30 contain data for the months of year 2, ...., columns 187 thru 198 contain data for the months of year 16. I need to set the ColumnWidth for columns 7 thru 198 to 4. I've never had a problem setting ColumnWidth before as I do this (among other things) for a living for the past 8 months. I've tried multiple methods, i.e., Range, Range-by-Range, Column-by-Column, and each one fails at column 149. Code: -------------------- Dim col As Integer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy & past row to column | Excel Discussion (Misc queries) | |||
sum if column heading in in past | Excel Worksheet Functions | |||
Sum if the column heading is in the past? | Excel Worksheet Functions | |||
Cannot set ColumnWidth past column 148 | Excel Programming | |||
column help- can I go past IV? | Excel Discussion (Misc queries) |