1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
Sub TestPresenterSur4LignesV2()
Dim J As Long
Dim FeuilleSource As Worksheet
Dim PremiereLigneSource As Long
Dim DerniereLigneSource As Long
Dim FeuilleCible As Worksheet
Dim LigneCibleEnCours As Long
Set FeuilleSource = Sheets("Feuil1")
Set FeuilleCible = Sheets("Feuil2")
LigneCibleEnCours = 2
With FeuilleSource
PremiereLigneSource = 5 ' à adapter
DerniereLigneSource = .Cells(.Rows.Count, 1).End(xlUp).Row
For J = PremiereLigneSource To DerniereLigneSource
With FeuilleCible.Cells(LigneCibleEnCours, 1)
.Value = FeuilleSource.Cells(J, 1) & " " & FeuilleSource.Cells(J, 3) & " " & FeuilleSource.Cells(J, 5) 'PresenterSur4Lignes(FeuilleSource.Range(FeuilleSource.Cells(J, 1), FeuilleSource.Cells(J, 6)))
.Offset(1, 0) = FeuilleSource.Cells(J, 2) & " " & FeuilleSource.Cells(J, 3) & " " & FeuilleSource.Cells(J, 4) & " " & FeuilleSource.Cells(J, 6)
.Offset(2, 0) = FeuilleSource.Cells(J, 5)
.Offset(3, 0) = ""
LigneCibleEnCours = LigneCibleEnCours + 4
End With
Next J
End With
Set FeuilleSource = Nothing
Set FeuilleCible = Nothing
End Sub |
Partager