When this code runs it starts to assign values in the array if th
conditions are true, but if the statements avaluate to false it move
to the next number in the array. Basically it is jumbling up m
results.

Is there a way to tell the array to evaluate each number across th
enitre named range before moving on to the next number? Thanks


For Each cell In range("G11:I125")
c = Array(5,4,3,2,1)
For i = 0 To 5
J = 356
K = 305
If Cells(J, c(i)).Value - 1 = Cells(K, c(i)) And cell.Value "" An
Cells(cell.Row, c(i) + 97) = "x" Then _
cell.Value = Cells(9, c(i) + 97)
Next i
Nex

--
Message posted from http://www.ExcelForum.com