Macro to Add Worksheet

[papaexcel]

I'm looking for a macro that will insert/add a new worksheet, and then move that newly created worksheet to the end of the workbook. Sounds simple but I can't figure out how to do it.


TIA!!

[sweep]

Please Login or Register  to view this content.

[papaexcel]

Perfect! Thanks!

[papaexcel]

One other request...I also want a macro that will delete all existing worksheets in a workbook (sometimes as many as 30 worksheets) except for Sheet1 and Sheet2.

Again, TIA!!

[sweep]

Please Login or Register  to view this content.

[papaexcel]

thanks, works great.

I found out the following works equally as well...

Please Login or Register  to view this content.

[papaexcel]

My problem continues to grow!! Thanks a ton for the help already.

But now I need to do one more thing. When I use the above macro to create a new worksheet and move it to the end of the workbook, I want to also automatically rename that worksheet based on the the cell "A1" in "Sheet1". Incidentally, cell "A1" in "Sheet1" will always be a date, but I plan having it formated such that it reads 5-15-09. Thus I would want the sheet name of the newly created sheet to read 5-15-09.

Any ideas?

Again, thanks for all the help.

[sweep]

Please note that an error will be generated if there's nothing in cell A1 on sheet1

Please Login or Register  to view this content.

[papaexcel]

Worked great. Thanks again...you've been most helpful.