Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add new named sheet
I want to add a worksheet to the workbook with a specific
name that is in a cell on an existing worksheet. How can this be done?? Thanx ahead, G. Carter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add new named sheet
One way:
Option Explicit Sub testme01() Dim newWks As Worksheet Set newWks = Worksheets.Add On Error Resume Next newWks.Name = Worksheets("sheet1").Range("a1").Value If Err.Number < 0 Then MsgBox "couldn't rename sheet: " & newWks.Name Err.Clear End If On Error Goto 0 End Sub GREG CARTER wrote: I want to add a worksheet to the workbook with a specific name that is in a cell on an existing worksheet. How can this be done?? Thanx ahead, G. Carter -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
add new named sheet
Worksheets.Add(After:=worksheets( _
worksheets.count)).Name = Activesheet.Range("B9").Value or sName = Activesheet.Range("B9").Value Worksheets.Add(After:=worksheets(worksheets.count) ) Activesheet.Name = sName -- Regards, Tom Ogilvy GREG CARTER wrote in message ... I want to add a worksheet to the workbook with a specific name that is in a cell on an existing worksheet. How can this be done?? Thanx ahead, G. Carter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem finding named sheet | Excel Discussion (Misc queries) | |||
Move a particular named sheet to the end. | New Users to Excel | |||
same Named cells in different sheet | Excel Discussion (Misc queries) | |||
Create a sheet name, won't let me, says already sheet named that | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions |