| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
I have the following code whereby I am trying to hide 91 columns, but it
croakes on the --- line below Columns("DI:DU").Hidden = True Columns("DV:EH").Hidden = True Columns("EI:EU").Hidden = True --- Columns("EV:FH").Hidden = True Columns("FI:FU").Hidden = True Columns("FV:GH").Hidden = True Columns("GI:GU").Hidden = True The error is "Unable to set the hidden property of the Range class", error 1004. Is there a maximum number of columns that can be hidden? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DOES EXCEL HAVE a MAXIMUM NUMBER OF COLUMNS PER WORKBOOK? | Excel Discussion (Misc queries) | |||
| Built-in Excel constant for maximum number of rows, for columns? | Excel Programming | |||
| Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| Excel Constants for maximum number of rows, columns? | Excel Programming | |||
Threaded Mode
