يظهر لي الخطأ run time error "6
over flow بالرغم انني راعيت حجم البيانات الكبيرفي نوع المتغيرات ولا اعلم لماذا هذا الخطأ يظهر
Sub mytest()
Dim g As Range, f As Range, i As Range
Dim positivevalue As Long, negativevalue As Long, positivevolume As Long, negativevolume As Long, resultevalue1 As Long
Dim resultevalue2 As Long
For Each g In Range(Range("g2"), Range("g5").End(xlDown))
For Each f In Range(Range("f2"), Range("f5").End(xlDown))
For Each i In Range(Range("i2"), Range("i5").End(xlDown))
If i >= 0 Then positivevalue = positivevalue + g
If i < 0 Then negativevalue = negativevalue + g
If i >= 0 Then positivevolume = positivevolume + f
If i < 0 Then negativevolume = negativevolume + f
resultevalue1 = positivevalue / positivevolume
resultevalue2 = negativevalue / negativevolume
Next
Next
Next
End Sub
عندما نفذت الكود خطوه خطوه يظهر الخطأ عند هذا السطر
resultevalue1 = positivevalue / positivevolume
resultevalue2 = negativevalue / negativevolume