| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Copy Sheet and move to end
Hi,
i have posted something similar earlier today but this is alittle different. I have a sheet called Template in a workbook. i need to be able to issue a macro that will copy it and move it to the far right after all other sheets. Then rename it 1 number above the last sheet. i.e. if the last sheet was 2567 then my new copied shett will be 2568. regards, N.S. |
|
#2
|
|||
|
|||
|
Sheets("TEMPLATE").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = Sheets.Count HTH -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "Nigel" wrote in message ... Hi, i have posted something similar earlier today but this is alittle different. I have a sheet called Template in a workbook. i need to be able to issue a macro that will copy it and move it to the far right after all other sheets. Then rename it 1 number above the last sheet. i.e. if the last sheet was 2567 then my new copied shett will be 2568. regards, N.S. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move or copy more then one sheet at a time | Excel Worksheet Functions | |||
| Copy sheet to new workbook | Excel Discussion (Misc queries) | |||
| In a protected sheet how do I get the cursor to only move to unlo. | Excel Discussion (Misc queries) | |||
| Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
| Option Buttons move after placing on sheet | Excel Worksheet Functions | |||
Hybrid Mode
