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

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 called > from a worksheet formula, the

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

f Of monkeyboy Sent: Sunday, December 11, 2011 9:11 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Worksheet Function Requires Range object as parameter Hello, I would like to use the Forecast worksheet function in an integration routine. It appears to require a Range object as the look u

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

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