Works great, but can I copy into a new workbook with out it referencing the
workbook it came out of?

"JBeaucaire" wrote:


One way:

=IF(ISERROR(AE1!A1),0,AE1!A1)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46793