View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
hotherps[_83_] hotherps[_83_] is offline
external usenet poster
 
Posts: 1
Default Automate this code

Yes Tom I noticed, I think I started that by accident. Anyway Here i
what I have at the moment:

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

The problem is that if the reference to Cells 356 and 305 is true th
code runs it's entire length. I need it to stop and check the cells on
row at a time down to
Cells 402 and 352
Thank

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