1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| Workbooks(origine).Sheets(VLookupResultCSV).Activate
For i = A To 5000
If Workbooks(origine).Sheets(VLookupResultCSV).Cells(i, 4) <> "" Then
i = i + 1
Else
x = i - 1
Exit For
End If
Next i
'cas aaaa
If UCase(Counterpart) = UCase("aaaa") Then
Workbooks(origine).Sheets(VLookupResultCSV).Range("A1:K" & x).Copy
Workbooks(name1).Sheets(index).Range("A1:K" & x).PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Else
Workbooks(origine).Sheets(VLookupResultCSV).Activate
Stock = WorksheetFunction.Match("Stock", Workbooks(origine).Sheets(VLookupResultCSV).Range("A:A"), False)
dercol = Cells(Stock, Columns.Count).End(xlToLeft).Column
cop = Range(Cells(2, 1), Cells(x, dercol)).Copy
Workbooks(name1).Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End If |