Yup, that did it.
I was unaware of "full recalc".

Then I deleted both comments. Everything went to #N/A as expected.
However, when I put one or both back, in any relevant cell, the function
cells remained at #N/A. Full recalc did not impact them in this scenario.

At the risk of belaboring this, should it not be dynamic?
Ie where there's a comment, there's a corrseponding column number.
Where there's not, the function would be #N/A.

Thanx again.
- Mike





"JE McGimpsey" wrote:

Try a full recalc - CTRL-ALT-F9

In article ,
"MikeF" wrote:

It's the first thing I tried ... nearly punched the f9 key off the keyboard
[!!].
Even went to Tools/Options and hit recalc there.