Test for outline level of cell

F

fgrose

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() ?
 
V

Vasant Nanavati

AFAIK, not without using a macro.
_________________________________________________________________________
 
F

fgrose

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?
 
V

Vasant Nanavati

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