Vary row number in a VBA formula

[Kishan]

Using Excel 2000</SPAN></SPAN>
Hi,</SPAN></SPAN>

I have a formula sumproduct running in the VBA =SUMPRODUCT(--($I$8:$L$8=C8:F8)) I want a loop once this formula is filled restart again filling with change of row number =SUMPRODUCT(--($I$9:$L$9=C8:F8)) change as long as data find in the column C and finish the process </SPAN></SPAN>

Sub FillFormlas_UMPRODUCT()
    
    Dim lngLastRow As Long
    lngLastRow = Cells(Rows.Count, "C").End(xlUp).Row
    
    Range("G8:G" & lngLastRow).Formula = "=SUMPRODUCT(--($I$8:$L$8=C8:F8))"
    Range("G9:G" & lngLastRow) = Range("G9:G" & lngLastRow).Value 'Convert Values
     
      
End Sub

Is it possible? </SPAN></SPAN>

Thank you in advance</SPAN></SPAN>

Regards,</SPAN>
Kishan</SPAN></SPAN>

 

[Kishan]

Please does any idea how to change the above sumproduct normal formula to R1C1 and than how to use it into a VBA?