SumbyColor Function

[tjh]

Hello,

I am using this SumbyColor function http://www.cpearson.com/excel/colors.htm

I use a macro to create a worksheet which has several of these SumbyColor
formulas throughout it. The macro has worked for years, but recently a few of
the cells with these formulas in them do not always calculate but display the
error "#NAME?." The only way to make these cells calculate (that I know of)
is to select the cell, type "F2", then "Enter." The cell then calculates
correctly. This is also only to a few of the cells, not all of them get this
error. Do you know why these would not calculate correctly, manually or
automatically? How can I fix this?

Thank you,

 

[Jim Thomlinson]

Not too sure how you lost your link to the UDF but you can try this to fix
it...

Shift + Ctrl + Alt + F9 (Full Calc of the sheet)
and/or
Find and replace on the = sign with an = sign to force the recalc...