View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default Find a Worksheet

Application.DisplayAlerts = False
Worksheets("sheetname").Delete
Application.DisplayAlerts = True

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Anice" wrote in message
...
Does anyone have a suggestion on how you could find a worksheet in a

written
code. You have the name, and you want the program to find that sheet and
delete it.

Thank you!