Macro with goalseek function

[Ramy27]

I recorded a macro in Excel while doing a goal seek. When I run the macro it's not repeating the goal seek. Could anyone tell me why? Here's the part of the macro that was recorded.

Range("B9").GoalSeek Goal:=0, ChangingCell:=Range("B4")

 

[mintjulep]

It works fine for me.

Have you changed cell B4 to something other than the sought answer? If the initial conditions already satisfy the goalseeker then it will appear to do nothing.