How do I use values i have calculated and output to rows again in another formula, in VBA:(

[KatieLarson]

Okay I have used a loop to calculate values for x and y and displayed both in seperate columns. I have put x in a column starting f2 and y in a column starting g2 how then do i then input these coordinates to another formula. It is to calculate the angle of a robot arm, the formula is (x^2 +y^2 -l1^2 - l2^2)/(2*l1*l2) i could input these into this no problem but only once. How do extract these coordinates and put them into the formula as many times as required??

Would love any kind of help some help

oh and this is what my loop looks like

For i = 0 To pointscir
Range("f" & i + 2) = ((r * (Cos((2 * Pi) * numpcir * i))) + a)
Range("g" & i + 2) = ((r * (Sin((2 * Pi) * numpcir * i))) + b)
Next i

 

[pbornemeier]

What do you mean by:
"How do extract these coordinates and put them into the formula as many times as required??"
Do you want to calculate sequential x & y positions of the arm so that the new position you obtain is fed into the formula?
What do you want as a result?