H
hotherps
I'm having a problem with the values K and T
For K = 305 To 316
For t = 319 To 330
For Each cell In Range("G11:N298")
c = Array(7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
For i = 0 To 13
If Cells(t, c(i)).Value - 1 >= Cells(K, c(i)) And
Cells(cell.Row, c(i) + 97) = "x" Then
cell.Value = Cells(9, c(i) + 97)
End If
Next i
Next
After the array and the rest of the code has finished I want t
increase the value of K by one and the value of T by one. No matte
where I put it I get an error. What am I missing?
Thank
For K = 305 To 316
For t = 319 To 330
For Each cell In Range("G11:N298")
c = Array(7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
For i = 0 To 13
If Cells(t, c(i)).Value - 1 >= Cells(K, c(i)) And
Cells(cell.Row, c(i) + 97) = "x" Then
cell.Value = Cells(9, c(i) + 97)
End If
Next i
Next
After the array and the rest of the code has finished I want t
increase the value of K by one and the value of T by one. No matte
where I put it I get an error. What am I missing?
Thank