Thread: Prompt msg if the worksheet already exits
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Prompt msg if the worksheet already exits
Sub dural()
For Each sh In Worksheets
If sh.Name = "Shop 1" Or sh.Name = "Shop 1 Pivot" Then
MsgBox (sh.Name & " already exists")
End If
Next
End Sub
--
Gary''s Student - gsnu200812
Reply With QuoteReply With Quote