ANother option

Check with

If SheetExists("results") Then
...

'-----------------------------------------------------------------
Function SheetExists(Sh As String, _
Optional wb As Workbook) As Boolean
'-----------------------------------------------------------------
Dim oWs As Worksheet
If wb Is Nothing Then Set wb = ActiveWorkbook
On Error Resume Next
SheetExists = CBool(Not wb.Worksheets(Sh) Is Nothing)
On Error GoTo 0
End Function



--

HTH

RP
(remove nothere from the email address if mailing direct)


"ajitpalsingh200" wrote in
message ...

hie,

How do i check whether the worksheet by the name of "results" exist or
not?

thankx in advance


--
ajitpalsingh200
------------------------------------------------------------------------
ajitpalsingh200's Profile:
http://www.excelforum.com/member.php...o&userid=16150
View this thread: http://www.excelforum.com/showthread...hreadid=276513