I created a module called foo
in my spreadsheet, and then I added the following to it:
Function foo() As Variant
foo = 5
End Function
When I try to run the function in Excel, by typing =foo()
into a cell, I get #NAME
. When I look at what #NAME
is supposed to mean by clicking on the little icon next to it and then help on this error
I get this:
Well, not exactly that, but it was about as useful.
Eventually I discovered that changing the module name to something other than foo
seemed to fix it. Have I stumbled upon a bug or a feature? Where is this behavior documented?