Cant get my DO WHILE Loop to function - Help please

Hi,

I am trying to produce a function that will update formulas based on the value of i. At present my code will copy and update the formulas across a range (rng1) based on the manual input of i. what i wish to do now is insert a loop that will increase the value of i by one each time until the range (rng1) is full. Within the loop I will need an IF statement to produce an updated formula that takes into account if i is less than or greater than 10.

Please help. been on this for a good few hours now and keep getting Type Mismatch errors.

Many Thanks!!

Hi Richard,

Firstly thanks for your response.

It seems functioning correct in terms of the loop. However, I think the problem may be that I am filling the Range of cells each time it loops. What I want to do is fill row 1 of the range in the first loop, row 2 of the range in the second loop, row 3 in ther third loop... etc.

Any ideas on how I can generate a row update rather than a range? Slightly puzzled

Thanks