ISBLANK can be used over a range if it is used in an array formula.

=AND(ISBLANK(H42:Cs42)) resolves to TRUE if the range is blank and the
formula is entered with CTRL+SHIFT+ENTER.

However, even when entering your formula as an array formula I get a #VALUE!
error.

What are you trying to do with this formula?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Niek Otten" wrote:

The argument for ISBLANK can only be one cell, not a range

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"strawberry" wrote in message oups.com...
| If all the cells within the given range are blank, the following
| formula evaluates to "#VALUE!"
|
| =IF(AND(ISBLANK(H42:CS42)),"",CHAR(MAXA(Sheet1!32: 32)))
|
| I'd be grateful if someone can tell me either how to correctly rewrite
| the formula or, failing that, how to supress the error. The error
| doesn't affect overalll performance. It's just rather unsightly.
|
| Any help greatly appreciated.
|