Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Need step by step to add invoice numbering to excel template | New Users to Excel | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |