Copy Marcro with Worksheet

[mycon73]

Hi Excel Users,

I have a task log worksheet & each week a copy & create a new one. The template is the same & each worksheet is labeled FW 1, FW 2, etc.

My macro doesn't seem to copy over when I change the worksheet name. How can I edit or create a new macro that will recognize & then change with the worksheet name?


Thanks

[Domski]

Do you mean you make a copy of a worksheet in the same workbook?

Dom

[royUK]

You should post your code for us to see. Use code tags

[Palmetto]

Not sure if this is helpful, but FWIW,

    Dim i As Long
    
    i = Sheets.Count
    
    Worksheets("Sheet1").Copy after:=Sheets(i)
    
    i = Sheets.Count
    Worksheets("Sheet1 (2)").Name = "FW" & i - 1

Where "Sheet1" is the name of the task log sheet.
The code copies this sheet, counts the number of sheets, offsets the count by -1 and renames the new sheet to "FW" and the sheet count.

Is this helpful?

[mycon73]

Hi,

Yes, I created a template in a Worksheet, then copy the whole worksheet, which carries over all my data, including the marcro.

Other than changing the worksheet name from FW 1 to FW 2, everything else is pretty much the same.


This seemed to work well with Excel 2003, but not so much in 2007.

I'll try the code that Palmetto just gave.

Thanks