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.

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.