Sheet.Range("AVAR1:KVAR1") = Sql.Range("AVAR1:KVAR1").Value Sheet.Range("MVAR2:KVAR2") = Sql.Range("MVAR1:KVAR1").Value
Range("AVAR1:KVAR1")
Range("X" & VAR2 & "")
Range("AVAR1:KVAR1")Je pensais que ça venait plus du
If ActiveCell.Value = Range("X" & VAR2 & "").Value Then
je ne sais pas comment sélectionner une plage de cellule avec des variables.
Range("A" & VAR1 & ":K" & VAR1).select
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDerniere_Ligne = Cells.Find("*", Range("A1"), , , xlByRows, xlPrevious).Row
If ActiveCell.Value = Range("X" & VAR2 & "").Value Then
If cells(VAR1,"G").Value = cells(VAR2,"X").Value Then ' ICI LE CODE POUR COPIER End if
Sub MacroTri3() Dim NbLig As Long, VAR1 As Integer, Cible As String, firstAddress As String, Adress As String, Y As String, VAR2 As Integer Dim FeuilleDesti as worksheet Dim Sql as worksheet Set Sql = Sheets("SQL-Results") Set FeuilleDesti = Sheets("Feuil1") For VAR1 = 2 To Cells.Find("*", Range("G2"), , , xlByRows, xlPrevious).Row For VAR2 = 2 To Cells.Find("*", Range("X2"), , , xlByRows, xlPrevious).Row If cells(VAR1,"G").Value = cells(VAR2,"X").Value Then FeuilleDesti .Range("A" & VAR1 &":K" & VAR1) = Sql.Range("A" & VAR1 & ":K" & VAR1).Value FeuilleDesti .Range("M" & VAR2 & ":K" & VAR2) = Sql.Range("M" & VAR1 & ":K" & VAR1).Value End If Next VAR2 Next VAR1 End Sub
Sub MacroTri3()
Dim NbLig As Long, I As Long, J As Long
Dim LigneDest As Long
Dim FeuilleDesti As Worksheet
Dim Sql As Worksheet
Set Sql = Sheets("SQL-Results")
Set FeuilleDesti = Sheets("Feuil1")
LigneDest = 2
NbLig = Cells.Find("*", Range("A1"), , , xlByRows, xlPrevious).Row
For I = 2 To NbLig
For J = 2 To NbLig
If Cells(I, "G").Value = Cells(J, "X").Value Then
FeuilleDesti.Range("A" & LigneDest & ":K" & LigneDest) = Sql.Range("A" & I & ":K" & I).Value
FeuilleDesti.Range("M" & LigneDest & ":X" & LigneDest) = Sql.Range("M" & J & ":X" & J).Value
LigneDest = LigneDest + 1
End If
Next
Next
End Sub