MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If worksheet exists


Posted by Ken on September 07, 2000 11:50 PM

Is there a statement you can use in VBA to say if a worksheet exists do this.
The same with workbook exists.


Posted by Celia on September 08, 0100 2:33 AM

Ken
To check if a worksheet exists in the avtive workbook :-

Sub ShExist()
Dim ws As Worksheet, sExist As Boolean
For Each ws In Worksheets
If UCase("the worksheet name") = UCase(ws.Name) Then
sExist = True
Exit For
End If
Next
If sExist = True Then
MsgBox "Yes"
Else
MsgBox "No"
End If
End Sub

To check whether a workbook exists :-

Sub WB_Exist()
If Dir("the full path and filename") <> "" Then
MsgBox "Yes"
Else
MsgBox "No"
End If
End Sub

Celia