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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
Whoops... actually it get the message on the Columns("FI:FU").Hidden = True
line. "Cheer-Phil-ly" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
Don,
The Excel file is almost 9mb and has private and confidential banking data so I can't send you the file. Does it matter if the columns have data or not? In my case they all have some data in some of the 960 rows. "Don Guillett" wrote: 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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
I wouldn't think it mattered. Without testing, maybe merged cells.??
I do confidential work for clients on a routine basis. Ex series 7 license holder and regional mgr for ING. -- Don Guillett SalesAid Software "Cheer-Phil-ly" wrote in message ... Don, The Excel file is almost 9mb and has private and confidential banking data so I can't send you the file. Does it matter if the columns have data or not? In my case they all have some data in some of the 960 rows. "Don Guillett" wrote: 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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
My best guess would be that you are trying to hide columns with merged cells
(spanning columns) in them. You can not hide half of a merged cell... One question though is why do you have so many ranges to hide when the ranges form one large continuous block of columns? You could try... Columns("DI:GU").Hidden = True -- HTH... Jim Thomlinson "Cheer-Phil-ly" wrote: Don, The Excel file is almost 9mb and has private and confidential banking data so I can't send you the file. Does it matter if the columns have data or not? In my case they all have some data in some of the 960 rows. "Don Guillett" wrote: 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? |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of hidden columns
or hide em all and just unhide desired
-- Don Guillett SalesAid Software "Jim Thomlinson" wrote in message ... My best guess would be that you are trying to hide columns with merged cells (spanning columns) in them. You can not hide half of a merged cell... One question though is why do you have so many ranges to hide when the ranges form one large continuous block of columns? You could try... Columns("DI:GU").Hidden = True -- HTH... Jim Thomlinson "Cheer-Phil-ly" wrote: Don, The Excel file is almost 9mb and has private and confidential banking data so I can't send you the file. Does it matter if the columns have data or not? In my case they all have some data in some of the 960 rows. "Don Guillett" wrote: 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? |
Reply |
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 |