Move Sheet

[MikeDBMan]

When I record a macro to move a data sheet within a workbook, I get something like this:

Sheets("Parameters").Move After:=Sheets(5)

There may or may not be hidden sheets in this file. How do I get the proper "Sheets(5)". I can't figure out what that is. I have no sheet by that name. It is not the "codename" property. What is it and how do I get it?

 

[VoG]

That's the 5th sheet as you view the tabs reading left to right. Where do you want it?