counting colored cell

[Joyce]

Hi
I don't know anything about VBA, but found a site that let's me download an
example to count the cells with colors
http://www.techonthenet.com/excel/questions/count_font_color.php) but even
when I downlaod the above the answer to the formula is #NAME?

Does anyone know why I get #NAME? as the answer?

Thanks
Joyce

 

[Gary''s Student]

It usually means that a User Defined FUnction cannot be found. It might be
in the wrong place.

 

[Gord Dibben]

Place both UDF's in a general module in your workbook.

Alt + F11 then CTRL + r

Select your workbook/project and Insert>Module

Copy/paste into that module


Gord Dibben MS Excel MVP