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,