Oh great ones,
I have a recorded macro which works fine when opened
the first time. How would I add a check for exsistance of
this specific sheet name to avoid the error you get when
you re-open the workbook? It will ultimately be a workbook
open event.
Excel 2003
Office 2003
Sub blank1()
Sheets("Blank").Select
Sheets("Blank").Copy Before:=Sheets(1)
Sheets("Blank (2)").Select
Worksheets("Blank (2)").Name = Format(Date - 1, "mm-dd-
yyyy")
End Sub
thanks,
Mike
Bookmarks