Signature lines won't transfer with via

[traub86]

I have a worksheet in workbook1 that complies information for the other worksheets and at the end of the day I need to export that specific worksheet to another workbook. So far I have no problem doing this, but the signature lines (8 total in a specific cell range) that I have there are not exporting like the rest of the document. My code is set to copy that worksheet and paste into the new one. So I'm not exactly sure what I'm doing wrong. Please help.

 

[Scott Huish]

Care to post your code?

 

[traub86]

Sub Copysht()
    Workbooks("FINAL_JUMP MANIFEST_FINAL.xlsm").Sheets("DZ LOG").Copy before:=Workbooks("DO NOT DELETE_MASTER DZ LOG.xlsm").Sheets(1)
    Workbooks("DO NOT DELETE_MASTER DZ LOG.xlsm").Sheets(1).Name = Format(Date, "DD-MM-YYYY") + " Chalk 1"
End Sub