Hello im trying to do a ranking with vba this is the summary of my code :
Dim RR1 As Range
Dim RG1 As Range
Dim rule1 As Variant
rule1 = ComboBox5.value
Set RR1 = ActiveSheet.Range(ActiveSheet.Range("C4").End(xlToRight).Offset(1, 6), ActiveSheet.Range("C4").End(xlToRight).Offset(1...