This is what i have so far and it works, but i want to add a line that tells it to ignore sheet 1.
Code:
Dim shtTemp As Worksheet
Application.DisplayAlerts = False
For Each shtTemp In ActiveWorkbook.Worksheets
If shtTemp.Range("A15") = "" Then
shtTemp.Delete
End If
Next
Application.DisplayAlerts = True
[\code]