Using goal seek to make a chart

Here is what I need to do.

On one worksheet ("UserInput"), users provide a desired output value. This output value lives in cell (9, 2).

On a different worksheet, there is a data table. The x-values are determined by a macro which works fine. The y-values are determined by a goal seek macro -- at least, they're supposed to be.

Here's the code:

Please Login or Register  to view this content.

Can anyone see what the problem is? I haven't been able to figure it out.

Alright -- I am beginning to suspect that the reason this is not working is because the goal-seek macro is getting into a time race with the line that calculates an initial guess. I think the goal-seek line begins to run before the calculations in the previous line are finished. Maybe.

So, a new question -- does anyone know of a way to force the macro to wait for the first line to complete before running the second? I found this web page

http://support.microsoft.com/kb/147392

but it's totally greek to me. Can anyone help?

Thanks!

Hi

1) should the line

Please Login or Register  to view this content.

really be referencing cells(9,3) or should it be cells(9,2)? Given the next line in the macro refers to the same cell for the goal seek????

2) If that doesn't help, can you put up a sample file that includes the relevant formulas being actioned.


rylo