Bonjour,
j'ai besoin de concatener 2 row avec leurs nom si vous pouvez m'aider, voici le code que j'utilise:
Dim rng1 As Range
Dim rng2 As Range
Dim rng3 As Range
Dim strF As String, strP As String
Dim wb As Workbook
Dim ws As Worksheet
Dim cell As String
Set wb = Workbooks.Open(strP & "\" & strF)
Set ws = wb.Sheets("feuil1")
Set rng1 = Sheets("feuil1").Rows(1).Find("Copy1")
Set rng2 = Sheets("feuil1").Rows(1).Find("destination")
Set rng3 = Sheets("feuil1").Rows(1).Find("Copy2")
cell = rng1 & rng3
Set rng1 = Range(rng1.Offset(1), rng1.Offset(Rows.Count - 1).End(xlUp))
ws.cell.Copy Destination:=rng2.End(xlUp).Offset(1)
End If
wb.Close True
strF = Dir()
Loop
End Sub