Trying to automate "Goal Seek" in a worksheet

Disclaimer: I have little experience with coding goal seek and/or Solver in VBA (usually I prefer to write my own root finding routines).

but the goal seek value seems like it needs to be hard coded and cannot reference a cell or be copied into the dialogue box.

My usual solution to this simple problem is to add a helper cell =current target cell formula - desired target value. Then Goal Seek/Solver/other root finding algorithm can be hard coded as "set target cell to a value of 0 by changing decision variable(s)." If that is the only problem you are having with your code (hard to say since you did not provide an example of any of the code you have tried), then that should solve that problem.

If you are interested, here's a tutorial spreadsheet I created and adapted to perform root finding in Excel using Newton Raphson algorithms without any VBA http://www.excelforum.com/tips-and-t...ind-roots.html

To run by a macro you'll need to strip out the absolute reference $ signs - I had luck selecting the cell after that:

Please Login or Register  to view this content.

Where RngDesig was the Cell Address without the $'s.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

This got close:

Please Login or Register  to view this content.

Hi mj,

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.