Weird eh? Although it is not fully satisfactory to walk away not knowing the
cause, sometimes you just have to move eon .

Glad you are sorted.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Don Wiss" wrote in message
...
On Tue, 13 Feb 2007, Bob Phillips wrote:

I can't say what you should do as I have never encountered that error,
but
the syntax for Application.Run is

HL = Application.Run("'CalcILF
Add-In.xla'!GetHazardLevel",Range("PremDist").Cells(j, 1).Value, HL)

that is

res = Application.Run("'some book.xls'!macro", 4, "input")

Hi Bob,

Thanks for the correct syntax. I converted all to using Run and removed
the
Reference. Then for some strange reason the add-in functions that resided
in spreadsheet cells went to #NAME?. Restoring the Reference cleared that
up. Removing it and they went back to #NAME?. Now as we all know functions
in add-ins should work in cells. So I tried giving the name of the add-in
in front of the call to the add-in's function. Lo and behold, not only did
that work but the add-in name disappeared from in front.

I tried some examples of large workbooks to test the Catastrophic Failure.
I transferred over the input data to have the same cases. I was not able
to
get the Catastrophic Failure with the Reference removed. But using the
current version I was able to get it. So it would appear that I have fixed
the problem.

Don <www.donwiss.com (e-mail link at home page bottom).