Hello again,

Well I've just figured out why the values display as 0... and read
about appropriate error trapping etc. However, I've just realised that
this is not an option as the result im linking to from another sheet is
actually 0! - as its the result of an addition of null cells.

The spreadsheet is too large to introduce error trapping to all the
Sum() functions, does anyone know of another way around this problem?

Untidy but effective is fine lol.

Cheers


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=553165