| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking for the existence of a worksheet
I'm hoping I'm not posting this again...I got an error last time.
Is there a way, within a cell's formula, to check for the existence of a worksheet? For example, in the worksheet titled "Record Sheet", in cell A50, I want to return the value of cell A1 from the worksheet titled "Round 1" providing that worksheet actually exists. If the "Round 1" worksheet doesn't exist, I want to return " " to cell A50 in the Record Sheet worksheet. It seems that I would start with an If statement but I'm not sure what function checks for the existence of a worksheet (or if there is one). thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking for the existence of a worksheet
=IF(ISERROR('Round 1'!A1),"",'Round 1'!A1)
If the sheet does not exist, the iserror should catch it and force the blank. -- Gary''s Student - gsnu200909 "Allen" wrote: I'm hoping I'm not posting this again...I got an error last time. Is there a way, within a cell's formula, to check for the existence of a worksheet? For example, in the worksheet titled "Record Sheet", in cell A50, I want to return the value of cell A1 from the worksheet titled "Round 1" providing that worksheet actually exists. If the "Round 1" worksheet doesn't exist, I want to return " " to cell A50 in the Record Sheet worksheet. It seems that I would start with an If statement but I'm not sure what function checks for the existence of a worksheet (or if there is one). thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Dependence Before Deleting Worksheet | Excel Worksheet Functions | |||
| Spell checking a protected worksheet | Excel Discussion (Misc queries) | |||
| Checking for exsitence of values in a different worksheet | Excel Discussion (Misc queries) | |||
| Checking for the existence of a characted in a string | Excel Discussion (Misc queries) | |||
| How do I check for existence of a worksheet? | Excel Worksheet Functions | |||
Linear Mode
