Hi all,
I have built up an equation in excel that gives an output in cell H18 corresponding to a value that was entered into cell A18.

I am trying to build a loop that will set H18 equal to the value of the cell B3 by changing A18. The value of B3 is 760 and this value cannot change.

I know I could use goal seek to turn cell H18 to 760 by manipulating A18 to the correct value. And I know that a record macro will give me the code for this. But the code must be in the form of a Do until loop. Can someone help? Thanks in advance
Stephen