In your #1 you said
[VBA]
on the "Number of repeat non conforming sites" row.
[/VBA]
I couldn't find a row with that label. Did I miss it?
In the mean time, you have 2 places with
[VBA]
Dim repeatNCCount As Integer
[/VBA]
Try making them Double and see if that does anything.
Paul