IF #REF1 = ERROR then #REFBLANK
 

=IF(ISERROR(IF(OR($A4=$B$2,$A4<$B$2),'W:\Aurora Daily Production
Report\2005\10_Oct\[2005October01.xls]Daily
Report'!$H$49,""))=TRUE,"",IF(OR($A4=$B$2,$A4<$B$2 ),'W:\Aurora Daily
Production Report\2005\10_Oct\[2005October01.xls]Daily Report'!$H$49,""))

Ok heres my code. Problem is the *.xls file isn't created yet. Which causes
me to press ESC for the referance. Is there a ISERROR or IF statement I
could use to have the referance just be blank ( "" ) if the referance doesn't
exsist.?