Guzzlr
Well-known Member
- Joined
- Apr 20, 2009
- Messages
- 982
- Office Version
- 2021
- Platform
- Windows
Code:
For Each sht In ActiveWorkbook.Worksheets
If sht.Visible And sht.Name = ("ASY") And sht.Name = ("TEMP") Then
sht.Delete
Worksheets.Add().Name = "ASY"
Worksheets.Add().Name = "TEMP"
Sheets("ASY").Move After:=Sheets("DATA")
Sheets("TEMP").Move After:=Sheets("ASY")
End If
Next sht
Hello All...
I'm having troubles with my code above to delete the sheets ASY and TEMP.
I've used this before, and it worked, but not now?
Thanks for the help