اخي ياسر
ورد خطأ بسيط في الكود و تمت المعالجة
Sub Tekrar()
Dim lr, Mymax, Myin, i As Integer
Dim Myrg As Range, m As String
lr = Cells(Rows.Count, 1).End(3).Row
Columns("F:g").ClearContents
Set Myrg = Range("A1:d" & lr)
Mymax = Application.Max(Myrg): Mymin = Application.Min(Myrg)
For i = 0 To Mymax - 1
If Mymin + i > Mymax Then Exit For
Range("f" & i + 2) = Mymin + i
Next
Range("f1") = "الأعداد": Range("g1") = "التكرار"
lr1 = Cells(Rows.Count, "f").End(3).Row
m = "countif( $A$1:$D$" & lr & ",F2)"
Range("g2:g" & lr1).Formula = "=" & m
Range("g2:g" & lr1).Value = Range("g2:g" & lr1).Value
Range("f2:g" & lr1).Sort key1:=Range("g2"), order1:=xlDescending
End Sub