Instead of
LN(range)
use
If(ISNUMBER(range),LN(range))
and array enter the formula.

Jerry

"Carrie_Loos via OfficeKB.com" wrote:

Thanks and sorry I should have been clear in defining my issues. I have
reposted the issue under Dynamic Range Name in Functions. It's true the
defined names work as long as I have a set range but the values change and if
there is a blank then I get the #VALUE! error. So I am trying to get a
dynamic range to work but so far I have not been successful.

Mike Middleton wrote:
Carrie -

You can use defined names Xrange and Yrange to refer to the numeric data
ranges on your worksheet. And if you change the Refers To range of both
defined names, the formulas will update. In Excel 2003, choose Insert | Name
| Define.

- Mike

By the way, can you use a dynamic range name for the Xrange & Yrange? I
can't
[quoted text clipped - 19 lines]
Thank you in advance for any asssistance.
Carrie

--
Message posted via http://www.officekb.com