worksheets(number).name = format(date(now), "mm-dd-yy") replace the (number)
with either the sheet number in the book or the current name of the sheet i.e.
worksheet(1) or worksheets("sheet2") etc for the first one.. if there is only
one sheet in the book then its 1 if there is more than one.. it would be a
little harder to figure out.. i'd stay with the "Sheet1" version