Always advisable for using dates in the format yyyy mm for sorting purposes.

--
HTH

-------

Bob Phillips
"Sherri" wrote in message
...
hi Frank,

I tweaked to

ActiveSheet.Name = Format(Date, "mm-dd-yy") & "-HD"

and it does what I wanted!

Thanks for the help!

Sherri