How can I ammend this so it tests the value of the cell 38 cols to the right for 0.
i.e.
cell C80 needs to be tested alongside AN80 if AN80 = 0 then forget the test
This can be by -1 from count or jumping out of loop and going on to next test.
This is what I have:
Martin
i.e.
cell C80 needs to be tested alongside AN80 if AN80 = 0 then forget the test
This can be by -1 from count or jumping out of loop and going on to next test.
This is what I have:
Rich (BB code):
For Each CSheetUID In CSheetUIDRng.Cells
res = Application.Match(CSheetUID.Value, SalesUIDRng, 0)
If IsError(res) And CSheetUID.Value <> "" **And Xn > 0** Then
'no match
count1 = count1 + 1
CSheetUID.Select
ActiveCell.Interior.ColorIndex = 6
ElseIf CSheetUID.Value <> "" **And Xn > 0** Then
count2 = count2 + 1
End If
Next CSheetUID
Martin