Hi
I have 2 user defined functions in my personal workbook.

Function GetFontColor(mycell As Range)

GetFontColor = mycell.Font.ColorIndex

End Function

Function GetFillColor(mycell As Range)

GetFillColor = mycell.Interior.ColorIndex

End Function

I have entered these formuilas
=getfillcolor(A1)
=getfontcolor(A1)
Both result in the #Name? error. What is the problem?
TIA