Create new worksheet
 

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!

Create new worksheet
 

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!

Create new worksheet
 

Worksheets.Add(After:=Worksheets(Worksheets.Count) ).Name = Format(Date,
"dd-mm-yy")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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!