Hello i have some code that i want to run, if the conditions are not met, remember that 1st time run and if data deleted that the condition would not be met. If the conditions are met i want to the code to run but for the next row.

The codes run for each row i = 5:29 so starting at B5 finishing at B29. The code runs for B5:G5 and then H5 is a calculated cell that sums up the values in (B5:G5) it is this cell (H5:H29) that i want to check against the conditions

The code randomly selects numbers from a named range ("ALL") or might be ("PartNumbers") depending on the pool of numbers required. It then puts them into row B5:G5 H5 is then Calculated if H5 is >=11 and <=170 then next row

If H5 is not >=111 and <=170 then repeat the selection process until condition is met, then advance to next row to perform the same code again all the way down to row 29 

Please Login or Register  to view this content.