heavy_user
New Member
- Joined
- Jul 10, 2008
- Messages
- 8
I have used a macro to do three goalseeks at the same time using
Private Sub Worksheet_Calculate()
Range("G14").GoalSeek goal:=7.5, changingcell:=Range("J14")
Range("G15").GoalSeek goal:=12.5, changingcell:=Range("J15")
Range("G16").GoalSeek goal:=21.5, changingcell:=Range("J16")
End Sub
However, XL returns the correct answer but then carries on trying to calculate something? I have to press escape and then click on end.
i think the macro is probably wrong but not sure how
any ideas gratefully recieved
Private Sub Worksheet_Calculate()
Range("G14").GoalSeek goal:=7.5, changingcell:=Range("J14")
Range("G15").GoalSeek goal:=12.5, changingcell:=Range("J15")
Range("G16").GoalSeek goal:=21.5, changingcell:=Range("J16")
End Sub
However, XL returns the correct answer but then carries on trying to calculate something? I have to press escape and then click on end.
i think the macro is probably wrong but not sure how
any ideas gratefully recieved