Does this mean you are all sorted out or just adding more info to help in
trouble-shooting?

If you are still getting the "ambiguous name" then you haven't looked hard
enough or in the right place(s).

If you desire, please email me the workbook to

gorddibbATshawDOTca change the obvious.


Gord

On Wed, 16 Dec 2009 07:38:01 -0800, Doug
wrote:

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