Re: $$Excel-Macros$$ Need help using Modules in Excel 2007

2013-03-27 Thread Paul Schreiner
- From: "gkad...@gkading.com" To: excel-macros@googlegroups.com Sent: Wed, March 27, 2013 11:30:28 AM Subject: $$Excel-Macros$$ Need help using Modules in Excel 2007 I've created a simple module in excel 2007: Function Sigmoid(t) Sigmoid=1/

$$Excel-Macros$$ Need help using Modules in Excel 2007

2013-03-27 Thread gkading
I've created a simple module in excel 2007: Function Sigmoid(t) Sigmoid=1/(1+exp(-t)) End Function The sigmoid function seems to work in formulas initially, but when file is saved, closed, then reopened, the formula's don't seem to work -- I get 'NAME' error in cell with formula indicating unre