View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Blue Blue is offline
external usenet poster
 
Posts: 23
Default Display Worksheet If It Exists

I have the following on a button

Sub makesheet()
Sheets("Master").Select
Sheets("Master").Copy after:=Sheets("Master")
ActiveSheet.Name = Format(Now, "dd-mmm")
End Sub

Trouble is if the sheet already exists I get an error message. What I want
is if the worksheet with today's date already exists make it active. If it
does not exist create sheet.

Thanks Blue