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?
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?