Thanks for the response.

In the Project Explorer I right-clicked Modules and went to Insert Module,
and then gave the module the name of CustomFunctions. I pasted the code
into that module. My formula is essentially the same used on the page to
which I linked in my original message, except that I modified it slightly
because my data range is only 7 rows instead of the 100 rows given in the
example. The formula I am using is:

=SUMPRODUCT(--(ColorIndex(A2:A8)=3),A2:A8)

According to the article, this should sum all cells in A2:A8 where the
background color is red.

--Tom

"Niek Otten" wrote in message
...
The function should be in a General module, not a Sheet module or a
Workbook module

But maybe one of the arguments is interpreted as a name that is not
recognized

What is your formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Thomas M." wrote in message
...
Excel 2007

I have a problem that has been driving me nuts. I created a code module
and have pasted a couple of user defined functions into the module. When
I am entering my formula into a cell and I start typing the name of the
function, I see that the function is listed in the drop-down list of
functions. That tells me that Excel recognizes the function. However,
after entering the formula I get a #NAME? error.

Here is a link to just one of the user defined functions that I've been
trying to use.

http://xldynamic.com/source/xld.ColourCounter.html#code

Other people have successfully used the function as-is without any
problems by doing exactly the same things that I've done. Yet, when I
try to use the function I just get the #NAME? error. Furthermore, I've
tried a number of different functions and with every one I get the #NAME?
error.

Is there something that I need to do in order to use custom functions,
like maybe install an add-in or something, or is there a configuration
setting that enables the use of custom functions?

Thanks for any help that you can offer.

--Tom