Did you put the code in a General module (not in a worksheet module, not in the
ThisWorkbook module)?
Did you remember to allow macros to run?
Jeroen, Boot wrote:
I maintain a spreadsheet created by someone else that calls user defined functions.
Recenty I needed to migrate to Office 2007. All worked fine in xl2003, but xl2007 returns #NAME?.
Even this simple test fails:
Public Function testFunc(MyValue As Variant) As Variant
testFunc = "You gave me " & MyValue
End Function
Can someone give me a hint where to start ?
EggHeadCafe - Software Developer Portal of Choice
The XML I-Ching: Tao of the DOM
http://www.eggheadcafe.com/tutorials...-tao-of-t.aspx
--
Dave Peterson