Goal Seek in a Macro

[mrogge2895]

I am attampting to write a macro where I use goal seek to solve for price
based on the desired IRR input. When I bring up goal seek, it forces me to
manually input a value, rather than allow me to reference a cell value as the
input variable. Is there anyway to reference a cell value as the value I
would like to solve for within my macro?

 

[galimi]

Yes. You can programatically change the cell that needs to be static to a
value and then change it back to a formula after you perform the goal seek.