Please forgive my ignorance on the subject, but my client has just asked me about the "Goal Seek" tool in Excel. They would like to know if the method it uses to perform its calculations can be reproduced using VBA code. My client has made some attempts to write calculations that are like the Goal Seek function, which has resulted in circular references, which we are clear need to cleaned up.
When you respond, please include a brief description of the function and when it's useful; useful articals that describe the function with concrete examples, and any sample VBA code that performs the iterative calculations internally.
I suspect I will become an expert on the subject before too long. --Peter Ferber