Office 2007: #NAME error on UD formulas that were fine in 2001

P

plh

I have changed a 2001 worksheet having numerous user defined functions such as:

Function VEPT_Pre(Sigma, ProcessTime, MTTF, MTTR)
'Variance of effective Process Time page 262 Formula 8.6
'pre-emtive failures
VEPT_Pre = (Sigma / Availability(MTTF, MTTR)) ^ 2 + _
((2 * ProcessTime * MTTR * (1 - Availability(MTTF, MTTR))) / Availability(MTTF,
MTTR))

End Function

These were working fine in 2001 but now in 2008 as Process.xlsm They are
generating #NAME errors. I was using them on one of the worksheets. If I try to
put one in a new cell the "insert function" fx at the end of the formula bar can
see it, but claims that it takes no arguments. But you can easily see the
arguments up there.
What do I have to do to get them to work again?
Thank You,
-plh
 
P

plh

Oh my dears! So this IS the same list that a access through my email account.
Sorry for posting the same question twice. But I must tell you that I am in a
terrible fix & need help because my grade for the summer depends on this and
the summer is almost over!
Thanx,
-plh
 
P

plh

Alas! I think I have helped myself. I thought I told it to turn on Macros but
there turned out to be another place I had to do that. These are my Macros, of
course I trust them!
-plh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top