How to automatically add a worksheet using macro?

[eva]

Can I add adding a worksheet in a macro? How do I do that?
Ex. I create a new macro. One of the steps in my macro is to insert a new
worksheet.

 

[Dave Peterson]

Dim NewWks as worksheet
set NewWks = worksheets.add
with newwks
.name = "Your New Name Here"
.range("A1").value = "Hi there"
End with

 

[eva]

Thank you

Dim NewWks as worksheet
set NewWks = worksheets.add
with newwks
.name = "Your New Name Here"
.range("A1").value = "Hi there"
End with