| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename a worksheet that includes a cell refeerence
I have the following code included in a macro:
Sheets("Week XX").Copy After:=Sheets(ActiveWorkbook.Sheets.Count) Application.Goto Reference:="'Week XX (2)'!R3C3" What I would like to do is rename the copied worksheet "'Week XX (2)!'" to: 'Week 19' where the number '19' is obtained from cell C3 of the worksheet. Each time I copy the worksheet cell C3 already has a new unique number displayed so there will be no chance of a worksheet ever being duplicated. Thanks for your assistance with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rename Worksheet From Cell Data | Excel Worksheet Functions | |||
| Rename Worksheet Tabs per Cell Content | Excel Programming | |||
| Rename a Worksheet on Input of Value in Cell | Excel Worksheet Functions | |||
| VBA to Rename Excel Worksheet Value of Cell. | Excel Programming | |||
| how do i rename worksheet to equal cell name | Excel Worksheet Functions | |||
Threaded Mode
