I want to set a check to identify if there are any errors on my worksheet
Sheet2

From sheet1 I have tired the following formula and it returns false, however
there
is a #Div/0! ON Sheet2.

=ISERROR(Sheet2!1:65536)

Can this possibly be done?

Burce

Hi!

Is it really necessary to check the ENTIRE sheet? Are you using all of those
cells?

Here's what you could do if you used a more reasonably sized range:

=SUMPRODUCT(--(ISERROR(A1:H1000)))

Sumproduct will not accept entire columns as range arguments. When I tried
this:

=SUMPRODUCT(--(ISERROR(A1:IU65535)))

That's the entire sheet less 1 column and 1 row.

Excel crashed so bad that even Task Manager couldn't regain control of my
machine!

Maybe a VBA soulution would be better if you MUST check the entire sheet.

Biff

"Bruce" wrote in message
...
I want to set a check to identify if there are any errors on my worksheet
Sheet2

From sheet1 I have tired the following formula and it returns false,
however
there
is a #Div/0! ON Sheet2.

=ISERROR(Sheet2!1:65536)

Can this possibly be done?

Burce