Goal Seek loop - VBA

I get a "file format not recognized" error trying to open your sample file.

I would expect at the heart of such a loop would be a statement calling the goalseek method of the range object: http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

Sometimes, especially if B8 and B12 can change, I prefer to add a helper cell to this kind of model =B8-B12. Then, when I call GoalSeek, I can have the goal be 0 by changing the input variable. This will save needing to figure out "what is the 'goal' value for this loop" step in running the loop.

Sometimes, I think the easiest way to get a starting point for code like this is to record a macro while I perform one iteration of the loop manually. Then I can modify that code and put it in the desired loop.