Hi
I may be missing something obvious.
In your original File you have no formulas past row 100, so you will never get any values returned after row 100
From the original chart 1:
Using Excel 2007 32 bit
Worksheet: Sheet1
Row\Col E F G H I J 99 =IF(G98>=$B$3,"",G98+1) =IF(F99="","",F99+$B$1) =IF(F99="","",I98+1) 100 =IF(G99>=$B$3,"",G99+1) =IF(F100="","",F100+$B$1) =IF(F100="","",I99+1) 101 102
Alan




Reply With Quote
Bookmarks