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?