Hi,

Im using Indirect.ext to pull in info from closed workbooks, The
problem is that if a workbook dont exist it displays #VALUE!, im then
doing sum calculations on this pulled in info but because of the
#Value! the sums wont work. Anyone know a work around??

Cheers


--
Stuartf
------------------------------------------------------------------------
Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535
View this thread: http://www.excelforum.com/showthread...hreadid=545007