Are you sure you *want* to pick up #VALUE!?

That often indicates a problem with logic in your sheet. I usually find
it's better NOT to mask errors, and instead prevent/fix them.


In article ,
"RFJ" wrote:

Tx all - you pointed me in the right direction. ISERROR was even better as
it picked up a VALUE error message as well.