UDFs Won't Run from Add-In

[Philip1957]

Greetings,

This is my first attempt at a UDF. I have the following saved to MyFunctions.xlam and the add-in is active in all of my workbooks.

Function CountCcolor(range_data As Range, criteria As Range) As Long
Dim datax As Range
Dim xcolor As Long

xcolor = criteria.Interior.ColorIndex

For Each datax In range_data
    If datax.Interior.ColorIndex = xcolor Then
        CountCcolor = CountCcolor + 1
    End If
    Next datax
End Function

The function shows up when I start typing in a cell ...

... but it gives me a #NAME error and I don't understand why.

What am I doing wrong?

Any assistance would be greatly appreciated.

Thank you,
~ Phil

 

[Philip1957]

I cleared the cells where I'm calling out this UDF.
I changed the name of the module so that it is different from the name of the function.
I then used the UDF in my workbook and the counts came out correct. So far, so good.
Then I saved & closed the workbook, reopened it, and found the correct results had become #NAME? errors again. Calculate Now didn't change a thing.
This is just bonkers.

 

[Fluff]

Maybe a stupid question, but did you save the add-in?

 

[Domenic]

And did you make sure to enable macros?

 

[Philip1957]

Yes, the add-in is saved.

Yes, macros are enabled. I'm trying to use the UDF in an xlsm workbook.