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.