Changing worksheet names

G

Guest

I have created a workbook that I want to use as a template to gether monthly
statistics. In the template workbook I ahve generically named the worksheets
MMM (for month), but when I use the copy of the template each month I need
the worksheet name to be the actual name of the month. I have formulas that
exist in the workbook that reference the individual worksheets and would not
want to have to update all the formulas each time to include the specific
worksheet name. Is this possible?
 
C

Corey

try something like:

ActiveSheet.Name = range("A1").Value

added into your copy sheet code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top