Re : Concatener lignes avec retour
Bonsoir
Sub test()
For i = 1 To 6
If Cells(i, 3) = "" Then
Range("E1") = Range("E1") & Cells(i, 2)
Else
Range("E1") = Range("E1") & Cells(i, 2) & " : " & Cells(i, 3)
End If
Range("E1") = Range("E1") & Chr(10)
Next i
End Sub
et avec ( : )
Sub test()
For i = 1 To 6
If Cells(i, 3) = "" Then
Range("E1") = Range("E1") & "( " & Cells(i, 2) & " )"
Else
Range("E1") = Range("E1") & "( " & Cells(i, 2) & " : " & Cells(i, 3) & " )"
End If
Range("E1") = Range("E1") & Chr(10)
Next i
End Sub