je souhaite remplacer la colonne "o"par la colonne de référence(col_ref)
voici le code :
col_ref = ThisWorkbook.Worksheets("calcul").Range("b2").Value
If Application.WorksheetFunction.CountIf(ThisWorkbook.Worksheets("base1").Range("o165536"), _
.Range("o" & i).Value) > 0 Then
Ligne1 = Application.WorksheetFunction.Match(.Range("o" & i).Value, _
ThisWorkbook.Worksheets("base1").Range("o165536"), 0)
il y quelque chose qui ne fonctionne pas dans ce code !!!! mais quoi??:
With ThisWorkbook.Worksheets("base2")
Derligne = .Range("a65536").End(xlUp).Row
For i = 1 To Derligne
col_ref = ThisWorkbook.Worksheets("calcul").Range("b2").Value
If Application.WorksheetFunction.CountIf(ThisWorkbook.Worksheets("base1").Range("& col_ref & 1:col_ref & 65536"), _
.Range(col_ref & i).Value) > 0 Then
Ligne1 = Application.WorksheetFunction.Match(.Range(col_ref & i).Value, _
ThisWorkbook.Worksheets("base1").Range("& col_ref & 1:col_ref & 65536"), 0)
next i
End if
End with