Hi!
I am trying to activate the goal seek function if the goal cell is not the same as the indirect solution to the function the goal seeker solves. The goal seeker activates but every time it solves the formulas it also makes my excel crash about 10 secondas afterwards.
I am aware that the solution is not exactly the same as the targeted solution but I don't know any good ways to make this happen just only once.
Private Sub Worksheet_Calculate()
If Cells(8, "p").Value <> Cells(8, "q").Value Then
For i = 8 To 91
Cells(i, "Q").GoalSeek Goal:=Cells(i, "p").Value, _
ChangingCell:=Cells(i, "r")
Next i
End If
End Sub
I have trade to change the if to
If Cells(8, "p").Value / Cells(8, "q").Value > 1.00001 Or Cells(8, "p").Value / Cells(8, "q").Value > 0.99999 Then
but no good results so far
Best Regards
E
Bookmarks