Hi Anne,

Try:

'=============
Public Sub Tester()
Dim SH As Worksheet

Set SH = Worksheets.Add(After:=Sheets(Sheets.Count))
SH.Name = Format(Date, "dd-mm-yy")
End Sub
'<<=============

---
Regards,
Norman


"Arne Hegefors" wrote in message
...
Hello! I have a macro that when I press a button I want it to create a new
worksheet. The name of the worksheet shall be the current date. I do not
know
exactly how to write this so I would really appreciate some help. Pls help
me
with this code! Thank you very much!