Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() With a list of names in column A, this code will add a sheet and name it from that list. If I add a few names to the list, how can I ignore the names with sheets already named from the list and add sheets for the new names? And keep the entire list intact. Thanks, Howard Option Explicit Sub SheetsAhoy() Dim MySnme As Range Dim c As Range Set MySnme = Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row) For Each c In MySnme Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = c.Value Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rename sheet if current sheet name exists | Excel Programming | |||
If Sheet Exists Q | Excel Programming | |||
If the sheet exists...., then | Excel Programming | |||
If sheet exists, then... | Excel Programming | |||
How can I know if a sheet exists ? | Excel Programming |