VBA function naming

[fishyy33]

I defined two functions and they are identical except the naming.
The "test1" function works but the other one does not. It returns "#REF!" error about this function.
Could you please explain to me why it is so?

The definitions of the functions are below:


=============================


[FONT=arial, helvetica, sans-serif]Function TT22221(a As Double) As Double[/FONT]
[FONT=arial, helvetica, sans-serif]TT22221 = WorksheetFunction.Log10(a)[/FONT]
[FONT=arial, helvetica, sans-serif]End Function[/FONT]
[FONT=arial, helvetica, sans-serif]
[/FONT]
[FONT=arial, helvetica, sans-serif]=============================[/FONT]
[FONT=arial, helvetica, sans-serif]
[/FONT]
[FONT=arial, helvetica, sans-serif]Function test1(a As Double) As Double[/FONT]
[FONT=arial, helvetica, sans-serif]test1 = WorksheetFunction.Log10(a)[/FONT]
[FONT=arial, helvetica, sans-serif]End Function[/FONT]


​=============================<wbr>=====​

 

[KenCriss]

Try putting an underscore in it

Function TT_22221(a As Double) As Double
TT_22221 = WorksheetFunction.Log10(a)
End Function

 

[shg]

A function name can't look like a cell reference.