I need to check from the Workbook1 whether the SheetName exists in the
Workbook2. (I have many workbooks to check.)
I'm trying to use
=IF(ISERROR('C:\[Workbook2.XLS]SheetName'!$A$1),"No","Yes")
It's working but if the SheetName has been created in the Workbook2 I have
#REF! in the Workbook1.

Probably, there is a better formula to do this.
Please, advise.

Thanks