Hi,

Put you Function in a standard module.
Regards,
Jean-Yves

"donty" wrote in message
...
I have written a function on the code for a sheet in my workbook eg

Public Function Test() As Double
return 1
End Function

However when I try to use it in a cell in my sheet like this =Test() I get
a
#Name error.

What am I doing wrong?