Thank you for your reply...

I decided that the use of the CountOfCF would serve me better.
=CountOfCF($AA3:$AK3,2)
I have these all the way down the column 3 to 1000. I tried changing the
fill color of RGB to 0,255,0 just to make sure that wasn't a problem. I
checked the modules to make sure there is not one with the name countofcf and
there was not. I tried the three functions in a general module and when it
didn't work I just placed them all in there. In order, I have:
Function ActiveCondition,
Function ColorIndexOfCF,
Function ColorOfCF,
Function GetStrippedValue,
Function CountOfCF,
Function SumByCFColorIndex

--
Thank you!


"Gord Dibben" wrote:

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"

.