| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a Sheet & Rename based on Cell Value Q
I am trying to copy an active sheet to a new sheet and rename based on
the value in A1 (which has a formula that produces a value of .. "London 07-09-07 12:30", but I'm getting debug on line ActiveSheet.Name = Range("A1").Value I guess its the way A1 is formatted, how can I do this? Thanks Sub Copy_Rename() Dim shtName As String shtName = ActiveSheet.Name ActiveSheet.Copy after:=ActiveSheet ActiveSheet.Name = Range("A1").Value Sheets(shtName).Activate etc etc End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a Sheet & Rename based on Cell Value Q
The colon character ":" is not allowed in a sheet name. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Sean" wrote in message I am trying to copy an active sheet to a new sheet and rename based on the value in A1 (which has a formula that produces a value of .. "London 07-09-07 12:30", but I'm getting debug on line ActiveSheet.Name = Range("A1").Value I guess its the way A1 is formatted, how can I do this? Thanks Sub Copy_Rename() Dim shtName As String shtName = ActiveSheet.Name ActiveSheet.Copy after:=ActiveSheet ActiveSheet.Name = Range("A1").Value Sheets(shtName).Activate etc etc End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a Sheet & Rename based on Cell Value Q
On Sep 7, 12:48 pm, "Jim Cone" wrote:
The colon character ":" is not allowed in a sheet name. -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Sean" wrote in message I am trying to copy an active sheet to a new sheet and rename based on the value in A1 (which has a formula that produces a value of .. "London 07-09-07 12:30", but I'm getting debug on line ActiveSheet.Name = Range("A1").Value I guess its the way A1 is formatted, how can I do this? Thanks Sub Copy_Rename() Dim shtName As String shtName = ActiveSheet.Name ActiveSheet.Copy after:=ActiveSheet ActiveSheet.Name = Range("A1").Value Sheets(shtName).Activate etc etc End Sub Thanks Jim, of course |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| How can I copy sheet, fill in cell from list and rename worksheet? | Excel Programming | |||
| How to copy a sheet and rename it with the value of two cells from the source sheet? | Excel Programming | |||
| Button to copy sheet, rename sheet sequencially. | Excel Programming | |||
Linear Mode
