Increment row but lock cell in a loop.

[Riosmitham]

I'm trying to calculate a value using a worksheet named data and then pasting that value into a call in a worksheet called design database. All the input for the data worksheet comes from the design database worksheet. The only problem is i need to run the program for each row in design database separately. To do this i want to create a loop so that it runs the program for that row then increments the row number and runs the program again.

This is my code so far

Please Login or Register  to view this content.

I need to be able to use the value of 'i' everywhere there is an R[] and on the last range select (for instance AX(i)) but i need to keep the same column for each one. I'm not sure how to do this.

[snb]

To me it's unclear what you want. An example file would be beneficial.
The lookup-formula can't be right.

Please Login or Register  to view this content.

[Riosmitham]

I managed to actually really tidy up my code and now it works fine. This is what i got.

Please Login or Register  to view this content.