Excel 2007 UDFs result in #REF! errors
Excel thinks your UDF is actually a cell reference!?!
For example:
Function a1(r As Range) As String
a1 = "X"
End Function
will fail even in ancient version of Excel.
Avoid assigning a name to a function that Excel can mis-interpret.
--
Gary''s Student - gsnu2007k
" wrote:
I get strange results when I try to create UDFs in Excel 2007 (using
Vista).
For example, if I name the function any of the following, I get a
#REF! error.
add1
sum1
vol1
However, I don't get such an error if I use
addone
sumone
volone
I never noticed this before in earlier versions of Excel and it was a
pain until I worked out what appeared to be going on.
Any comments about this behaviour (and anything else that may be
associated)? For example, I presume this has been done to preserve
key names, which suggests any key name with just an integer after it
could be suspect.
Thanks,
Chris
|