View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick B[_6_] Rick B[_6_] is offline
external usenet poster
 
Posts: 12
Default checking for duplicate worksheets

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