Copy worksheet and rename sheet

  • Thread starter Thread starter Ernst - EXE Graphics
  • Start date Start date
Put the new name in a cell, say A1 and run this macro:

Sub Macro1()
ActiveSheet.Copy After:=Sheets(1)
ActiveSheet.Name = Range("A1").Value
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Worksheet 1
worksheet renames - specific 0
How do you copy and rename linked worksheets? 1
Sheet tab names change automatically 3
Need Help With Macro to set a value in new sheets 2
Worksheet Names is Defined by Cell value on Sheet 1 (named Summary 7
Worksheet renaming 5
Cannot copy worksheet to another file 2

Back
Top