Subscript out of range in VBA copying a template

[SethFD]

Hello. I come here seeking help, I have tried searching for a solution for this but i still don't know what's wrong.

I have this error: Run-time error '9': Subscript out of range.

In debug it opens my VBA:

Application.ScreenUpdating = False 'Hide screen flashing while creating and sorting
Sheets("Template").Visible = True 'Make sheet visible before Copy
> Sheets("Template").Copy After:=Sheets(3) 'copy template
ActiveSheet.Name = NewNameToAdd 'rename new sheet
Sheets("Template").Visible = False 'Hide Template

The stop line is Sheets("Template").Copy After:=Sheets(3)

I have never had a problem with this before, and no matter how I run it, I get the same error.

[Norie]

How many worksheets does the workbook the sheet 'Template' is in have?

[SethFD]

18 currently

[SethFD]

Also.... it appears for some reson, It's not there. I'm going to fix that.

[SethFD]

That was the weirdest thing ever. How does a hidden sheet just disappear?

[Norie]

Is there definitely a sheet with the exact name 'Template' in the active workbook when you run the code?

[Norie]

Could it have been renamed rather than disappeared?

[SethFD]

Could it have been renamed rather than disappeared?

The VBA has been run many times before, I can see no way it could have done that. I unhide the the template, make a copy, hide the template. And the template is only accessed if I'm editing functions.