Saturday, September 18, 2010

Sheets Handling

Delete sheet without “delete” notification
Application.DisplayAlerts = False
Sheets("List").Select
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

Add a new sheet
Set NewSheet = Worksheets.Add
NewSheet.Name = "Sheet Name"
Posted by Zeck at 11:30 PM
Labels:

No comments:

Post a Comment

Please add if your have better information.

Subscribe to: Post Comments (Atom)