Does a worksheet exist

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I tell if a particular sheet exists in a workbook

If it exists I want to delete it and create a new sheet with the same name

Kaval
 
I guess I could run a little routine to scroll through each sheet in the workbpok and see if I get a match, but I was hoping for a one line solution if possibl

Kaval
 
One way

Sub DelSheet()
Application.DisplayAlerts = False
On Error Resume Next
Sheets("sheet2").Delete
On Error GoTo 0
Application.DisplayAlerts = False
Sheets.Add
ActiveSheet.Name = "SHEET2"

End Su
 
Here is my previous posted code all done on one line

Application.DisplayAlerts = False: On Error Resume Next:
Sheets("sheet2").Delete: On Error GoTo 0: Application.DisplayAlerts =
False: Sheets.Add: ActiveSheet.Name = "SHEET2"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet exists 2
Addin - Invalidate Error 3
If named sheet exists then delete it 9
Excel VBA 0
clear all sheets code 4
adding footer to all existing sheets in workbook and also to newsheets which is added 1
Excel crashes and restarts when accessing newly created worksheet 2
Help with copying a sheet from One workbook to another workbook 1

Back
Top