Showing posts with label Excel : Sheets. Show all posts
Showing posts with label Excel : Sheets. Show all posts

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"