I'm guessing I'm not being clear with what I'm trying to accomplish. Let's go back to my original post. As you see it, I want to move columns F G and I over to C D and E, starting at C4. I want it to do what it does just start at C4 and continue no matter the limit in B3. Right now if I put 600 as the limit it stops at 417 in H100 and 99 in I100 and it should keep going to 600 and whatever the corresponding number in I column. If you go back to chart1 open it and leave the spacing at 2 and start at 120 but change the limit to 600 you'll see what I mean. I need it to continue now if there has to be a true limit then make it 999. Also I just want to move the calculations over to C column and start at C4. The "spacing, start and limit" have to be able to change, see it's a ratio like 1:3 with 3 being the spacing with whatever the start is and then the limit. So a 1:2 with a 600 limit. I suppose that the error is when it's trying to calculate the spacing with the start and the limit.
I've beat this until I see spots, at first I thought it was in a substring at the beginning but I can't find it. I'm slowly learning through various youtube videos. Hopefully I've made it clearer. If not, I don't know what to do.