Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming worksheets
I want to have a code to copy the worksheet called "invoice" and once it is
copied I want it to change its name to what ever is in cells "G13" Thanks again Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming worksheets
Something like this should work:
Dim Wname As String Wname = Worksheets("Sheet1").Range("G13") Worksheets("Sheet1").Copy after:=Worksheets _(Worksheets.Count) ActiveSheet.Name = Wname You don't have to use the "after:=Worksheets _(Worksheets.Count)", all that does is put the new sheet at the end, you can put it wherever you want. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming worksheets
Hi Greg,
ActiveSheet.Copy Befo=Worksheets(Worksheets.Count) ActiveSheet.Name = Range("G13").Value -- HTH RP (remove nothere from the email address if mailing direct) "Greg B" wrote in message ... I want to have a code to copy the worksheet called "invoice" and once it is copied I want it to change its name to what ever is in cells "G13" Thanks again Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming worksheets | Excel Worksheet Functions | |||
RENAMING WORKSHEETS | Excel Worksheet Functions | |||
Renaming worksheets | Excel Discussion (Misc queries) | |||
Renaming Worksheets | Excel Programming | |||
Renaming worksheets! | Excel Programming |