I just tested both of yours and got no error on either
send be your workbook if desired.
--
Don Guillett
SalesAid Software

"Cheer-Phil-ly" wrote in message
...
I have tried both of these...
Range("DI:GU").EntireColumn.Hidden = True
Range("DI:DU,DV:EH,EI:EU,EV:FH,FI:FU,FV:GH,GI:GU") .EntireColumn.Hidden =
True
Neither of them works.... same error.

"Don Guillett" wrote:

try this idea instead
Range("A:C,E:F,H:J").EntireColumn.Hidden = True

--
Don Guillett
SalesAid Software

"Cheer-Phil-ly" wrote in message
...
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?