$$Excel-Macros$$ Worksheet Function Requires Range object as parameter

2011-12-11 Thread monkeyboy
Hello, I would like to use the Forecast worksheet function in an integration routine. It appears to require a Range object as the look up value, my code carries this value as a double. Is there a way to wrap the value into a Range object without having to reference the worksheet explicitly? Funct

Re: $$Excel-Macros$$ Worksheet Function Requires Range object as parameter

2011-12-16 Thread monkeyboy
Thank you very much. This has been super helpful! On Dec 12, 9:22 pm, "Asa Rossoff" wrote: > Hello monkeyboy, > > Functions actually can modify worksheets.  It's only when the functions are > called from a worksheet formula that they can't.  When afunctionis c