Copy & Rename Worksheet

[srdavisgb]

Thanks in advance for your assistance...

I am populating information in a template in a worksheet with vlookups. I want to move a copy of the worksheet to a new workbook. I recorded the steps and have the following code:

Sheets(Template).Select
Sheets(Tempate).Move

The macro stops at this point. I think it is looking for a command to indicate where to move the worksheet.

How do I indicate a new workbook?

Also, I want to paste the vlookup values in the template copy so there is no link to the original workbook. Do I do this before the move or after? I want to preserve the vlookup values in the template. How would you recommend doing this?

Again, thanks for your assistance.

 

[VoG]

Try like this

Sheets(Template).Copy
With ActiveSheet.UsedRange
    .Value = .Value
End With

The new workbook will be the active workbook and you will need to save it (manually or with code).