Test for outline level of cell
 

Is there an expression that will return the cell's outline level that can be
used for an array criteria, such as in =SUMIF() or =SUMPRODUCT() ?

Test for outline level of cell
 

AFAIK, not without using a macro.
__________________________________________________ _______________________

"fgrose" wrote in message
...
Is there an expression that will return the cell's outline level that can
be
used for an array criteria, such as in =SUMIF() or =SUMPRODUCT() ?

Test for outline level of cell
 

Thank you.

Is there a macro or VBA function that could interoperate with the SUMIF() or
SUMPRODUCT() worksheet functions, or would I have to replace them with my own
code that reads the outlinelevel property?

Should I post the question in the Excel programming forum?

Test for outline level of cell
 

You would have to write a custom function to return the outline level and
then you could use it like any ordinary Excel function.
__________________________________________________ _______________________


"fgrose" wrote in message
...
Thank you.

Is there a macro or VBA function that could interoperate with the SUMIF()
or
SUMPRODUCT() worksheet functions, or would I have to replace them with my
own
code that reads the outlinelevel property?

Should I post the question in the Excel programming forum?