Bonjour à tous, je souhaite faire une concatenation des deux colonnes mais je n y arrives pas. Voici mon code ainsi que mon fichier ci joint
Sub aller()
Dim colonne As Variant, ligne As Variant, colonnea As Variant, ligneb As Variant
Dim nb_ligne As Variant, y As Variant, z As Variant, nb_ligne2 As Variant, nb_ligne3 As Variant
Dim a As Variant, d As Variant, c As Variant
colonne = Range("B3").Column
ligne = Range("B3").Row
colonnea = Range("d3").Column
ligneb = Range("d3").Row
nb_ligne = WorksheetFunction.CountA(Range("B:B"))
nb_ligne2 = WorksheetFunction.CountA(Range("D"))
nb_ligne3 = nb_ligne + nb_ligne2
MsgBox nb_ligne3
For y = 4 To nb_ligne + 2
a = Sheets("feuil1").Cells(y, colonne).Value
MsgBox a
Next
For z = 4 To nb_ligne2 + 2
d = Sheets("feuil1").Cells(z, colonnea).Value
MsgBox b
Next
For c = 3 To nb_ligne3
Rows(c, 7) = a & d
Next
Sub aller()
Dim colonne As Variant, ligne As Variant, colonnea As Variant, ligneb As Variant
Dim nb_ligne As Variant, y As Variant, z As Variant, nb_ligne2 As Variant, nb_ligne3 As Variant
Dim a As Variant, d As Variant, c As Variant
colonne = Range("B3").Column
ligne = Range("B3").Row
colonnea = Range("d3").Column
ligneb = Range("d3").Row
nb_ligne = WorksheetFunction.CountA(Range("B:B"))
nb_ligne2 = WorksheetFunction.CountA(Range("D"))
nb_ligne3 = nb_ligne + nb_ligne2
MsgBox nb_ligne3
For y = 4 To nb_ligne + 2
a = Sheets("feuil1").Cells(y, colonne).Value
MsgBox a
Next
For z = 4 To nb_ligne2 + 2
d = Sheets("feuil1").Cells(z, colonnea).Value
MsgBox b
Next
For c = 3 To nb_ligne3
Rows(c, 7) = a & d
Next