Sub Verification()
Dim Class As Workbook, FÀVrf As Worksheet, FBase As Worksheet
Set Class = Workbooks("BASE_à_vérifier.xlsm")
Set FÀVrf = Class.Worksheets("BASE_à_vérifier_ktp")
Set FBase = Class.Worksheets("base_à_comparer_cash_solutions")
FÀVrf.[J2:J200].FormulaR1C1 = "=IF(COUTIF(" _
& FBase.[F2:F200].Address(True, True, xlR1C1, True) _
& ",RC8)>0,""ok"",""Ligne non rapprochée"")"
FÀVrf.[J2:J200].Value = FÀVrf.[J2:J200].Value ' cette instruction est peut être facultative ?
End Sub