Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Interops] OutlineLevel and Hidden property
Dear NG,
I am programming against Excel using C# and the interops. I am trying to access the property OutlineLevel or the Hidden property of a range. It compiles fine but throws the exception: "Unable to get the OutlineLevel property of the Range class" "Unable to get the Hidden property of the Range class" How can I come around this? Regards, Patrick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Interops] OutlineLevel and Hidden property
An entirerow or entirecolumn is hidden, not a single cell.
? activecell.entirerow.Hidden True I don't believe a range will have an outlinelevel unless it is part of an outline. -- Regards, Tom Ogilvy "Patrick Kowalzick" wrote in message ... Dear NG, I am programming against Excel using C# and the interops. I am trying to access the property OutlineLevel or the Hidden property of a range. It compiles fine but throws the exception: "Unable to get the OutlineLevel property of the Range class" "Unable to get the Hidden property of the Range class" How can I come around this? Regards, Patrick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Interops] OutlineLevel and Hidden property
Dear Tom,
An entirerow or entirecolumn is hidden, not a single cell. Perfect. Thanks I don't believe a range will have an outlinelevel unless it is part of an outline. The outline level is 1 for the case mentioned. But, same as above, an entirerow or entirecolumn has an OutlineLevel, not a single cell (or Range). Thanks. Saved my mood for today :). Patrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the alternative for PlotArea.Fill. Fill property is hidden | New Users to Excel | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Is there a Filename property in PrintOut property | Excel Programming | |||
Run Time Error 1004 Unable to set hidden property | Excel Programming | |||
OutlineLevel and Integer Variable issue | Excel Programming |