Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Hello my macro works properly, I am hoping there is something I can do to not have the two shapes I use "GET PHT" and "CLEAR" (lanuch Macros) are left off the new worksheet I have created with the macro below.
Thank you very much!
Thank you very much!
VBA Code:
Sub Copy_SURFACE_PHT()
Set ws = Sheets("PHT")
ws.Copy After:=Sheets("PHT AIR")
Set wsNew = Sheets(Sheets("PHT AIR").Index + 1)
wsNew.Name = "PHT SURFACE"
End Sub