Mar 30, 2005 · Set objWorksheet = objWorkbook.Worksheets(“Sheet1”) objWorksheet.Copy, objLastSheet. Note what happens when we do this; we get a copy of Sheet1 — named Sheet1 (2) — inserted immediately after Sheet3, just the way we wanted: Having copied and inserted the new worksheet all that’s left is to rename Sheet1 (2). 3 ways to rename a worksheet Double-click the sheet tab, and type the new name. Right-click the sheet tab, click Rename, and type the new name. Use the keyboard shortcut Alt+H > O > R, and type the new name.

Jan 28, 2019 · On the sheets tab which is at the end of the Excel sheet, click the right button of the cursor on the sheets tab for which you want to rename the sheet. Clicking right will open a list of options to choose from. Right click on the sheet you want to rename On this list, you can see the option for ‘rename’. Sheets("Sheet1").Select Sheets("Sheet1").Name = "File 1" "Sheet1" in this case will change in name next time I want to run the macro , so it will fail. How can I build in a variable for the sheet selection so I can always rename it 'File 1' , whatever it used to be. It's always and only the first sheet I'm applying this to , by the way.