Goal Seek in a Macro

  • Thread starter Thread starter mrogge2895
  • Start date Start date
M

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?
 
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.
 
Back
Top