Excel VBA functions generating #REF based on function name?

Question

I am using Excel 2010 and have defined the following 3 functions in a spreadsheet module.

Option Explicit

Public Function AAA() As Double

    AAA = 3
End Function

Public Function AAA2() As Double

    AAA2 = 4
End Function


Public Function AAA3AAA() As Double

    AAA3AAA = 5
End Function

When I reference the three functions in my spreadsheet by entering the following into 3 adjacent cells

=AAA()
=AAA2()
=AAA3AAA()

The second function generates a #REF error. Other features work as expected. Does anyone know why this is happening? The reason I ask is because some of my macros stopped working when I upgraded from Office XP to Office 2010. After quite a bit of experimentation, it seems like the function name is the culprit? The error did not occur in Excel from Office-XP.

Answer 1

. , , "AAA2" . , .