You have to plce your code in a Module.

--
AP

"Bill Brehm " <<don't want any spam a écrit dans le message de
...
I opened the VB editor and added a simple function to the General sheet. I
tried both ThisWorkbook and the specific sheet.

Public Function Ripple(x As Double) As Double

Ripple = x

End Function

In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a
#Name? error. How do I get the spreadsheet to recognize the VB function?