Hi Gregor,

You can use an if and iserror statement on your worksheet to test i
your array formula returns an error. Where it does substitute th
system error message for your user defined error message.

ie: =if(iserror(array_formula),"",array_formula)

This is an easier way than trying to manipulate through code.

HTH

Cheers,

B

--
Message posted from http://www.ExcelForum.com