Sub Concat()
Dim conc(), n&, i&, bool&
With ActiveSheet
'comme on commence le tableau en ligne 1 pas la peine de se casser la tete
n = ActiveSheet.UsedRange.Rows.Count
ReDim conc(1 To n)
For i = 2 To n
bool = Abs(.Cells(i, 7) <> "" And .Cells(i, 8) <> "")
If bool = 1 Then conc(i - 1) = Replace((.Cells(i, 7).Value & "." & .Cells(i, 8).Value) & "/EXCEL", " ", "") 'modifier le nom de l'entité avant de lancer
Next i
Application.EnableEvents = False
.Cells(2, 3).Resize(UBound(conc) + 1, 1).Value = Application.Transpose(conc)
Application.EnableEvents = True
End With
End Sub