View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Macro to delete sheets

Sub Macro()
Application.DisplayAlerts = False
Sheets("PLANID").Delete
'to delete both
'Sheets(Array("PLANID","FEETOTAL")).Delete
Application.DisplayAlerts = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Jodie" wrote:

How can I delete sheets with the names PLANID or FEETOTAL through VBA?
--
Thank you, Jodie