Hi
How can i combine the 2 if statements?
It is making me have to run my code twice, is it because of the'next?
I want to do this in one shot if statement. Any advise?
Dim ws As Worksheet
Dim ws2 As Worksheet
For Each ws In Worksheets
If ws.Name = "SummaryPL" Then
Application.DisplayAlerts = False
Sheets("Sheet1").Delete
Application.DisplayAlerts = True
End
End If
Next
For Each ws2 In Worksheets
If ws2.Name = "Manual adjustment" Then
Application.DisplayAlerts = False
Sheets("Sheet2").Delete
Application.DisplayAlerts = True
End
End If
Next
Bookmarks