Hi all,

i want to check in an Excel file for a tab name for example "AAA" and see if
this tab name is exist in the file or not everyone please help me.

Thanks,
--
Farhad Hodjat

Have a look at

http://spreadsheetpage.com/index.php...vba_functions/

Success!!

--
met vriendelijke groetjes


"Farhad" schreef in bericht
...
Hi all,

i want to check in an Excel file for a tab name for example "AAA" and see
if
this tab name is exist in the file or not everyone please help me.

Thanks,
--
Farhad Hodjat

Something like this function should work...

Private Function SheetExists(sname) As Boolean
On Error Resume Next
IsError ActiveWorkbook.Sheets(sname)
SheetExists = Err.Number = 0
End Function

Just call it from your own code (macro, function, event procedure, etc.)
like this...

MsgBox SheetExists("AAA")

The function returns True if the sheet exists and False if it doesn't exist.

--
Rick (MVP - Excel)


"Farhad" wrote in message
...
Hi all,

i want to check in an Excel file for a tab name for example "AAA" and see
if
this tab name is exist in the file or not everyone please help me.

Thanks,
--
Farhad Hodjat