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>=====
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>=====