Making for adding and naming a new sheet

Giganews Newsgroups
Subject: Making for adding and naming a new sheet
Posted by:  michaelberrier (michaelberri…@gmail.com)
Date: 29 May 2006

I have a workbook with sheets named "Inventory-May" or whatever the
month is.  Like everyone else, I would like to automate this process.
I've found code here to do one or the other, but am having no success
sticking them together.

Basically, I need a macro to create a new sheet and rename it with a
static term, "Inventory", and then the successive month from the active
sheet.

Thanks to all.

Replies