Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting colored cell
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/qu...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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting colored cell
It usually means that a User Defined FUnction cannot be found. It might be
in the wrong place. -- Gary''s Student - gsnu200794 "Joyce" wrote: 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/qu...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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting colored cell
Place both UDF's in a general module in your workbook.
Alt + F11 then CTRL + r Select your workbook/project and InsertModule Copy/paste into that module Gord Dibben MS Excel MVP On Fri, 27 Jun 2008 06:17:01 -0700, Joyce wrote: 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/qu...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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting cells with colored font | Excel Worksheet Functions | |||
Counting colored cells | Excel Discussion (Misc queries) | |||
how to filter through a colored cell which has no value??? | Excel Discussion (Misc queries) | |||
counting colored cells | Excel Discussion (Misc queries) | |||
Counting Colored cells in a database | Excel Discussion (Misc queries) |