Copy worksheet and rename sheet

's Computer Specifications

How can I copy a worksheet and rename at the same time?

's Computer Specifications

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?

's Computer Specifications

If I got you right! just do a "Save-As"
HTH
John
"Ernst - EXE Graphics" <(E-Mail Removed)> wrote in
message news:523A3D3B-BD3D-4EE5-B06C-(E-Mail Removed)...
> How can I copy a worksheet and rename at the same time?

's Computer Specifications

OP said sheet

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If I got you right! just do a "Save-As"
> HTH
> John
> "Ernst - EXE Graphics" <(E-Mail Removed)> wrote
> in message news:523A3D3B-BD3D-4EE5-B06C-(E-Mail Removed)...
>> How can I copy a worksheet and rename at the same time?
>

's Computer Specifications

Thanks Don, I knew I needed more coffee this morning.
John
"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> OP said sheet
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "John" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> If I got you right! just do a "Save-As"
>> HTH
>> John
>> "Ernst - EXE Graphics" <(E-Mail Removed)> wrote
>> in message news:523A3D3B-BD3D-4EE5-B06C-(E-Mail Removed)...
>>> How can I copy a worksheet and rename at the same time?
>>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i rename a sheet if the rename tab is inactive?	Nelson	Microsoft Excel Worksheet Functions	1	3rd Mar 2010 11:28 AM
Copy worksheets to new worksheet and add a worksheet name column to new sheet.	Lib	Microsoft Excel Programming	1	22nd Feb 2007 05:30 PM
How can I copy sheet, fill in cell from list and rename worksheet?	radlee@progressivetel.com	Microsoft Excel Programming	5	31st Jul 2006 07:44 AM
How to copy a sheet and rename it with the value of two cells from the source sheet?	Simon Lloyd	Microsoft Excel Programming	0	12th May 2006 01:31 AM
Button to copy sheet, rename sheet sequencially.	foxgguy2005	Microsoft Excel Programming	9	17th Jun 2005 01:41 PM