Comparing Variants [Excel 2010/14] (VBA Only)

I can't tell what you're trying to do. Maybe this:

    For i = 1 To rCount
        For j = i + 1 To rCount
            If srgbdyPart(j) = srgbdyPart(i) Then
                srgFeeValue(j) = 0
            Else
                srgFeeValue(j) = srgFeeValue(j) * 0.75
            End If
        Next j
    Next i