| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy worksheet and rename sheet
How can I copy a worksheet and rename at the same time?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy worksheet and rename sheet
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 -- Gary''s Student - gsnu200796 "Ernst - EXE Graphics" wrote: How can I copy a worksheet and rename at the same time? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy worksheet and rename sheet
If I got you right! just do a "Save-As"
HTH John "Ernst - EXE Graphics" wrote in message ... How can I copy a worksheet and rename at the same time? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy worksheet and rename sheet
OP said sheet
-- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... If I got you right! just do a "Save-As" HTH John "Ernst - EXE Graphics" wrote in message ... How can I copy a worksheet and rename at the same time? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy worksheet and rename sheet
Thanks Don, I knew I needed more coffee this morning.
John "Don Guillett" wrote in message ... OP said sheet -- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... If I got you right! just do a "Save-As" HTH John "Ernst - EXE Graphics" wrote in message ... How can I copy a worksheet and rename at the same time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro REQ: Automatically copy a template sheet and rename | Excel Worksheet Functions | |||
| macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| Copy/Rename a sheet | Links and Linking in Excel | |||
| copy cell from one sheet of worksheet to another sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
