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?