I used the code below to copy active workbook to a new workbook. It works fine .

But when I used the same as below in another workbook, my excel crashes .

Note I recieved a batch of workbook from same supplier with same format , only contents which changes .



Sub copyactive()
ActiveWorkbook.Sheets.Copy
End Sub


I used another code

get runtime error 9, scriptt out of range



Sub copySheetsA()
'
'
ThisWorkbook.Sheets(Array("Page 1", "corps", "derniere_ page")).Copy

End Sub