How to automatically add a worksheet using macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eva - 05 Dec 2007 11:12 GMT

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.

Reply to this Message

Dave Peterson - 05 Dec 2007 12:27 GMT

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

> 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.

Signature

Dave Peterson

Reply to this Message

eva - 06 Dec 2007 01:49 GMT

Thank you

> Dim NewWks as worksheet
> set NewWks = worksheets.add
[quoted text clipped - 6 lines]
> > Ex. I create a new macro. One of the steps in my macro is to insert a new
> > worksheet.

Reply to this Message