Delete Worksheet.
 

Hi,
what is the macro to delete the Worksheet? Example. I
have three worksheets. Sheet1, Sheet2 and Sheet3. I would
like to delete the sheet1.

Delete Worksheet.
 

Hume, Sheets("Sheet1").Delete

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Hume" wrote in message
...

Hi,
what is the macro to delete the Worksheet? Example. I
have three worksheets. Sheet1, Sheet2 and Sheet3. I would
like to delete the sheet1.

Delete Worksheet.
 

Hume,

Sub DeleteSheet()
Application.DisplayAlerts = False
Worksheets("Sheet1").Delete
Application.DisplayAlerts = True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Hume" wrote in message
...

Hi,
what is the macro to delete the Worksheet? Example. I
have three worksheets. Sheet1, Sheet2 and Sheet3. I would
like to delete the sheet1.