determine if a sheet name exists

mikezx10 · #1 (**permalink**) 06-12-09, 11:18

Rather than going through each sheet in a work book, is there another way to determine if a sheet exists??

Ax238 · #2 (**permalink**) 06-12-09, 12:18

Sure, the following code will do it:

Code:

    Dim ws As Worksheet, Exists As Boolean
    On Error Resume Next
    Set ws = ActiveWorkbook.Sheets("SheetName")
    Exists = Not ws Is Nothing
    On Error GoTo 0

Regards,

Ax

Internet Services

Web Development

Digital Marketing

Consumer Tech