running loop multiple times?

hi, what im looking to do is run a looping sub procedure multiple times. for example if i had a row running from 1 to 10. i have a loop that will take the number in the first row, run it through a loop to determine a specific answer and then post the result in the next column along. i would then want the loop to look at the number on the next row, calculate the value and post the value in the opposing column. this would continue from 1 to 10 each time running the loop and posting the result in the opposing columns.

ive created the loop and have used an IF function to post the result in the next column for the first row, but i cant for the life of me work out how to restart the loop for each row after.

thanks tom

tom - we're none of us psychic, so post a workbook!

hi, i assumed it would be a general line of code specific to a loop function.

i have 1 sub procedure that calculates temperature every row. i then want to use the following code to look at the temperature, run the loop and post the value for "ntot" in the next column.

Please Login or Register  to view this content.

im currently using an inputbox to enter temp, i can change that to cell "a1" for example, what i cant work out is how to run the code again for "a2", "a3" and so on and then post ntot in "b1", "b2" etc.

thanks tom

anybody got an idea?