I want to copy a sheet to the end and give it a new name. The following code will copy the sheet but errors out before it names it saying object required.
Code:
Sheets("copySheet").Copy(After:=Worksheets(Worksheets.Count)).Name = shtName & "svd"