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

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

2011-12-12 Thread Asa Rossoff
Hello monkeyboy, Functions actually can modify worksheets. It's only when the functions are called from a worksheet formula that they can't. When a function is called from a worksheet formula, the function is considered a UDF or "user-defined function". When the function is called from other VB