Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a new worksheet and naming it according to a specific cel
Hey I'm trying to create a scipt that will creat a new worksheet and name
that new worksheet according to a cell in a particular other worksheet. Or I would like it to name it according to what the selected cell is before the macro runs. How can I do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a new worksheet and naming it according to a specificcel
On Jun 18, 9:05*pm, Surfbreakn2000
wrote: Hey I'm trying to create a scipt that will creat a new worksheet and name that new worksheet according to a cell in a particular other worksheet. Or I would like it to name it according to what the selected cell is before the macro runs. How can I do this? hello, This code will create a new sheet and name it based off the cell A1 value in "Sheet1" Worksheets.Add(After:=Sheets(Sheets.Count)).Name = Worksheets("Sheet1").Range("A1").Value This code will create a new sheet and name it based off the value in the active cell Worksheets.Add(After:=Sheets(Sheets.Count)).Name = ActiveCell.Value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet | Excel Worksheet Functions | |||
Creating and Naming a Folder and populating it with files | Excel Programming | |||
Creating 64 new wsheets and naming them in vba | Excel Programming | |||
Creating and naming new worksheets | Excel Programming | |||
Creating & Naming a New Worksheet | Excel Programming |