(Solved) – Copy/paste from another workbook

(solved)-–-copy/paste-from-another-workbook

It is a simple task, but I don’t know why it is not working…

This is my code :

Dim chemin As String
Workbooks.Open ("Z:ext_Workbook.xlsx") 
Sheets("produits").Activate
Sheets("produits").Range("A1:CZ500").Copy 

ThisWorkbook.Activate
Sheets("STT").Select
ActiveSheet.Range("A1").Select
ActiveSheet.Paste

Application.DisplayAlerts = False
Workbooks("ext_Workbook.xlsx").Close

The run stop at the line :

 Sheets("STT").Select

But I verified, and there is a sheet named “STT”, with the same spelling

Leave a Reply

Your email address will not be published. Required fields are marked *