| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if the sheet/tag exists
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
| check if worksheet exists | Excel Worksheet Functions | |||
| Check if a number exists in a range? | Excel Discussion (Misc queries) | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Threaded Mode
