Code:
Sub CreateCopy3()
Set Workbook= ActiveWorkbook
Sheets([{"Weekly Planning", "Contact Details"}]).Copy.Move
End Sub
The above code copies the first two sheets of a workbook and places them in a brand new workbook. It works, but I keep getting a "Run-time 424: Object Required Error" on the last line nonetheless. This could be a problem as I want to place this sub within another one, and this error may cause the whole thing to break. Does anyone know what the error could refer to?