I have this formula in xl 2002 SP3:

=INDEX($A$1:OFFSET(A$1,lastContigRow-2,),MATCH(SUBTOTAL(5,$B$1:INDIRECT("B"&lastContigR ow-2)),$B$1:INDIRECT("B"&lastContigRow-2),0))

"lastContigRow" is a named range (cell) and works fine. Right now
it's Row 477.

The formula successfully shows the contents of a certain cell in
Row A that is not hidden.

When I give that formula a name and try to invoke that name, however,
Excel crashes instantly.

Can anyone offer any help? I would like to know why this crashes xl,
but more important yet is finding a way to replicate the function without
crashing xl.

=dman=