Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have written a little VBA to create a new worksheet tab. The naming of
this tab is obtained from a specific cell. If a worksheet name already matches data that is entered into that cell, an error occurs. How do I first check if the worksheet name does not already exist before trying to rename the new sheet? Sheets("Template").Select Sheets("Template").Copy After:=Sheets(2) Sheets("Template (2)").Select ActiveSheet.Name = Sheets("StartHere").Range("B3") Thanks in advance, Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for checking duplicate numbers | Excel Discussion (Misc queries) | |||
Macro for checking duplicate entries | Excel Worksheet Functions | |||
Checking for duplicate entries | Excel Discussion (Misc queries) | |||
Checking for duplicate entries over multiple worksheets | Excel Discussion (Misc queries) | |||
Checking for duplicate records / rows | Excel Discussion (Misc queries) |