View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cheer-Phil-ly Cheer-Phil-ly is offline
external usenet poster
 
Posts: 21
Default 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?