Venkatesh,

You have two choices AFAICS, that is loope through all sheets and put the
name into an array, and check your proposed name against that, or try and
create it, and if it exists, try with a new name.

Here is some code to test if it exists

Function SheetExists(Filename As String)
Dim oSh As Worksheet
On Error Resume Next
Set oSh = ActiveWorkbook.Worksheets(Filename)
On Error GoTo 0
SheetExists = Not oSh Is Nothing
End Function


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"kvenku " wrote in message
...
Hi,
I need to add a new sheet thru macros which i have done. But now i
need to know the sheets name that alreday been existing.
I got the sheets.count. But i am not getting the name of the sheet.

How to know this.
Can any one help me to reach this

Thanks
Venkatesh.


---
Message posted from http://www.ExcelForum.com/