Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Naming a newly inserted sheet using VBA
I want to insert a new sheet and name it "ABC":
Sheets.Add Sheets("Sheet1").Name = "ABC" This is fine for the first time as it inserts a new sheet called "Sheet1". However the next time I do it the newly inserted sheet is called "Sheet2", but the code is still looking for a "Sheet1". Can I do something simple like: Sheets.Add.Name = "ABC" Thanks in advance. |
#2
|
|||
|
|||
What happened when you tried it?
(It worked for me.) Ant wrote: I want to insert a new sheet and name it "ABC": Sheets.Add Sheets("Sheet1").Name = "ABC" This is fine for the first time as it inserts a new sheet called "Sheet1". However the next time I do it the newly inserted sheet is called "Sheet2", but the code is still looking for a "Sheet1". Can I do something simple like: Sheets.Add.Name = "ABC" Thanks in advance. -- Dave Peterson |
#3
|
|||
|
|||
Yes it does work the first time, but Excel automatically calls the second
sheet "Sheet2" in the workbook so it will debug as it will be looking for "Sheet1". Actually I have just tried the following and it seemed to work... Sheets.Add Dim oSheet As Worksheet Dim sName As String sName = "ABC" Set oSheet = Application.ActiveSheet oSheet.Name = sName "Dave Peterson" wrote: What happened when you tried it? (It worked for me.) Ant wrote: I want to insert a new sheet and name it "ABC": Sheets.Add Sheets("Sheet1").Name = "ABC" This is fine for the first time as it inserts a new sheet called "Sheet1". However the next time I do it the newly inserted sheet is called "Sheet2", but the code is still looking for a "Sheet1". Can I do something simple like: Sheets.Add.Name = "ABC" Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get other sheet names into a column | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Copying Specific Values From Sheet | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Subset of one sheet on another sheet | Excel Worksheet Functions |