Delete blank worksheets in a workbook
Sub DeleteBlankSheets() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim X As Worksheet For Each X In ActiveWorkbook.Worksheets If WorksheetFunction.CountA(X.Cells) = 0 And ActiveWorkbook.Sheets.Count > 1 Then X.Delete Next X Application.ScreenUpdating = False Application.DisplayAlerts = False End Sub