VB Script - copycells

[dtrom26]

Hi

Hoping someone can help. I am looking for VB code to copy a sheet (Sheet1) from a spreadsheet called 21.xlsm to a sheet (Sheet 1) within an Excel file called 22.xlsm. The pasting of contents from the original sheet can override that within the destination sheet.

Hoping someone can help. I am not familiar with VB code.

Thank you

 

[mumps]

Place this macro into a regular module in "22.xlsm". Make sure both workbooks are open and then run the macro:

Sub CopySheet()
    Workbooks("22.xlsm").Sheets("Sheet1").ClearContents
    Workbooks("21.xlsm").Sheets("Sheet1").UsedRange.Copy Workbooks("22.xlsm").Sheets("Sheet1").Cells(1, 1)
End Sub

 

[Derek73]

Deleted. Someone else answered.