This has been mentioned before. See

http://www.google.com/groups?selm=Rv...s.uswest.n et

and

http://www.google.com/groups?selm=39...6%40alcatel.de

I thought I'd read a MSKB article on the subject, but cannot find it
now.

It is possible the error is because the function uses an iterative
approach and for those specific values it gets trapped in an endless
pattern.

You might also want to check Jerry Lewis' suggestion at
http://www.google.com/groups?selm=3F...0no_e-mail.com

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have already done this kind of test, I use an excel
Sheet, put number 1 to 3500 in the "A" column, and get
the ChiInv solution on each values from 1 to 3500
(probability = 0.05) in the column "B", I get error on
value 818 but not 817 nor 819, it also bug on 928 to 948
values... there must be a logic behind that but cannot
catch it...


-----Original Message-----
Test your values in a worksheet using the formula in the
worksheet (not in
VBA).

If you get a #Value or #Ref or something like that,
check the Excel VBA help
and see what conditions cause that error to be displayed.

When you use WorksheetFunction.ChiInv, then a condition
that would return a
# type error in the worksheet raises a 1004 error in VBA.

Regards,
Tom Ogilvy



"Stef C" wrote in
message
...
Hi,

I am using the ChiInv function of Excel and get an
error
1004 when sending some values, but no error sending
other
values... it do not seem to be an error from a certain
value (ex: start bugging when sending a value of 512 or
more...) it seem to be random, but I know that it is
not... anybody know this one.


.