=Calcs!R3C7:R62C7

SO THAT ANSWERS THE QUESTION! I didn't have the range defined for the entire
column.

Excuse me while I give myself a dope slap upside the head.

"JE McGimpsey" wrote:

How is

colNetSurrenderValue_AT

defined?

Conversely, are there valid values in the named range?

In article ,
Dkline wrote:

The only way I can get this to work is to not use the
"=colNetSurrenderValue_AT" but use the cell reference instead "=Calcs!RC7".
There are 121 rows in each column.

While using the "=colNetSurrenderValue_AT" I tried to coopy the last cell
before the #value to that first bad cell. It returns the #value.

When I try it in formula audit, it returns #value.

So I do have a solution - use the cell reference rather than the named
range. I just would like to know why the named range stops working in
mid-stream for only one column. All the other columns that point to a named
range are fine.

It's a mystery to me.