In general if your_formula give an error, then use:

=IF(ISERROR(your_formula),"",your_formula)
--
Gary''s Student - gsnu200908


"james" wrote:

getting the)
what about stopping a cell saying; #VALUE!
i have about 100 clees doing this when unused rows are left blank, any way
of doing this in bulk?