Dave,

But I'm not using a function built into excel, I'm using a formula with six
if statements and several polynomials. Would the UDF improve this?

Thanks

Adam Bush

"Dave Peterson" wrote:

My bet is no.

For the most part, UDFs are much slower than using the functions built into
excel.

You may want to read Charles Williams' notes on calculation:
http://www.decisionmodels.com/calcsecrets.htm

wrote:

Dave,

How about if I have a very long formula with if statements. Would it speed
up calculations to create a function in VBA rather than putting this long
formula in every cell?

Thanks

Adam Bush

"Dave Peterson" wrote:

Just my guess...

I'd bet any difference in calculation would close to unnoticeable by the human
eye. I think the better reason for doing it is to make updates easier. And
using a nice name can make the formula much more self-documenting, too.


wrote:

If I'm referring to a cell many times in a workbook, is there any difference
between linking to the cell reference (ie $A$3) or naming the cell and
linking to the name? Would it speed up calculations to link to a name?

Thanks

Adam Bush

--

Dave Peterson


--

Dave Peterson