Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rename the new worksheet
i kindly ask for help.
in sheet1 i have a list, i need to create a new worksheet and name it with the value of cell which i selected in this list. i tried something like this, but it´s surely very simple Sub Create() Dim ws As Worksheet Dim wsName As String If Not IsEmpty(ActiveSheet.ActiveCell.Value) Then Set ws = Worksheets.Add ws.Move After:=Sheets(Sheets.Count) ws.Name = ActiveSheet.ActiveCell.Text End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
why can't I rename my worksheet? | Excel Discussion (Misc queries) | |||
rename worksheet | Excel Discussion (Misc queries) | |||
rename worksheet | Excel Programming | |||
Rename worksheet | Excel Programming |