Re: $$Excel-Macros$$ Worksheet Function

2015-01-09 Thread Eugene Bernard
gt; *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wes

Re: $$Excel-Macros$$ Worksheet Function

2015-01-08 Thread Paul Schreiner
ns you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Eugene Bernard >To: excel-macros@googlegroups.com >Sent: Thursday, January 8, 2015

$$Excel-Macros$$ Worksheet Function

2015-01-08 Thread Eugene Bernard
Please find attached a sheet, where i am facing a error in the one liner macro. TIA Regards Eugene -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

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
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

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