need to ad one more step to code
 

All I am trying to do is have the code go through it's loop until the i
statement is fase.
At that point the Cells range should change to the next row, until i
reaches the end of it's range.

For Each CELL In Range("G11:N125")
c = Array(15, 14, 13, 12, 11, 10, 9, 8, 7)
For i = 0 To 8
If Cells(356, c(i)).Value - 1 = Cells(305, c(i)) And CELL.Value "
And Cells(CELL.Row, c(i) + 97) = "x" Then _
CELL.Value = Cells(9, c(i) + 97)
Next i
Next

if the statement was false the code would try to run again using Cell
357 and Cells 306 etc. etc.

The two actual ranges a

G356:AA403
and
G305:AA352


Thank

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