Hello All,
I am adding a new sheet and moving to correct location with:
However, when I use the code below, it consistently Faults, I've checked the spelling and all that is correct, so I'm at a loss why?
Thanks for the help
I am adding a new sheet and moving to correct location with:
VBA Code:
Sheets.Add().Name = "Spray Booth 1 PVT"
Sheets("Spray Booth 1 PVT").Select
Sheets("Spray Booth 1 PVT").Move After:=Sheets(3)
However, when I use the code below, it consistently Faults, I've checked the spelling and all that is correct, so I'm at a loss why?
Code:
Sheets.Add().Name = "Spray Booth 1 PVT"
Sheets("Spray Booth 1 PVT").Move After:=("Spray Booth 1")
Thanks for the help