functions to check it a worksheet exist in a workbook

[Tang]

I would like to check if a worksheet exist using excel formula, is there one
like this:
=if (Sheets("ABC") exist, "yes", "no")

regards

 

[Frank Kabel]

Hi
try this workaround
IF(ISERROR(INDIREKT("'sheetname'!A1")),"no","yes")

 

[Tang]

Wow, so fast, thank a lot. How about doing it in VBA?

regards
Tang

 

[Frank Kabel]

Hi
one way:

public function sheet_exist(sname) as boolean
dim wks as worksheet
on error resume next
set wks = activeworkbook.worksheets(sname)
on error goto 0
sheet_exist = not wks is nothing
end function