1 2 3 4 5 6 7 8 9 10 11 12
| Sub TEST()
Dim Cel As Range
For Each Cel In Range([a2], Cells(Rows.Count, "a").End(xlUp))
If Cel <> "" Then Cel.Offset(0, 1) = IIf(Cel.Offset(0, 2) <> "", Range("c1") & " : " & Cel.Offset(0, 2) & Chr(10), "") & _
IIf(Cel.Offset(0, 3) <> "", Range("d1") & " : " & Cel.Offset(0, 3) & Chr(10), "") & _
IIf(Cel.Offset(0, 4) <> "", Range("e1") & " : " & Cel.Offset(0, 4) & Chr(10), "") & _
IIf(Cel.Offset(0, 5) <> "", Range("f1") & " : " & Cel.Offset(0, 5) & Chr(10), "") & _
IIf(Cel.Offset(0, 6) <> "", Range("g1") & " : " & Cel.Offset(0, 6), "") & _
IIf(Cel.Offset(0, 7) <> "", Cel.Offset(0, 7), "")
Next Cel
End Sub |
Partager