So you have decided to go with the color functions rather than the Z1
=AVERAGE(range_to_average)?

The error message "ambiguous name" would indicate you have duplicate
CountOfCF functions or you have named a module CountOfCF.

Do you now have the three functions in a general module?

Did you delete the functions you had placed in in the sheet module?


Gord

On Fri, 11 Dec 2009 19:23:01 -0800, Doug
wrote:

After putting the three functions into a module, when I reset the value in
the column it says "Ambiguous name detected: CountOfCF"