[Interops] OutlineLevel and Hidden property

[Patrick Kowalzick]

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

 

[Tom Ogilvy]

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.

 

[Patrick Kowalzick]

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