[RESOLVED] Renaming Worksheets

[lexII]

I used this to rename worksheets in an old project of mine.
H3 is used to store the date in a text format (from A23) before being deleted

' Rename New Sheet to dd-mmm
Range("H3").Formula = "=Text(A23, ""dd"" & ""-"" & ""mmm"")"
ActiveSheet.Name = Range("H3")
Range("H3").Formula = ""

adding the year should be easy enough. ..mm"" & ""-"" & ""yyyy"")"