After the Activesheet gets copied, the copy now becomes the Activesheet.

ActiveSheet.Copy After:=ActiveSheet
ActiveSheet.Name = Format(Date, "mmddyyyy")


Gord Dibben MS Excel MVP

On Tue, 30 Dec 2008 10:58:05 -0800, Jeff Parrott
wrote:

I have a workbook that I do not use every day, but when I use it I need to
copy the contents of the last sheet to a new worksheet and then name the new
sheet with the current date. What I have now is very simple, since the
worksheet I want to copy is always the active sheet I just used the following:

ActiveSheet.Copy After:=ActiveSheet

Now I want to name the new sheet whatever the current date is. Any ideas?