ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "GoalSeek method of Range object failed" error message (https://www.excelbanter.com/excel-programming/320742-goalseek-method-range-object-failed-error-message.html)

Fixit_Steve

"GoalSeek method of Range object failed" error message
 
I'm using a spin button on a worksheet and I want to call a subroutine that
performs a GoalSeek from the spinbutton_spindown procedure. I have the
following spinbutton procedure and goalseek procedure.

Private Sub Cout_Spin_SpinDown()
Worksheets("Capacitors").Calculate
Range("Cout").Value =
Worksheets("Capacitors").Range("Cap_next_value_dow n")
Worksheets("Data").Calculate
Calc_Crossover
Worksheets("Main").Calculate
End Sub

Sub Calc_Crossover()
Range("C45").GoalSeek Goal:=0, ChangingCell:=Range("B45")
End Sub

The Calc_Crossover works fine when I run it as a macro. I have tried to run
it programatically with the Calc_crossover routine in a separate module and
on the same sheet as the spin_button routine. The range used for the
GoalSeek is on a separate worksheet "Data", however, I have used the
worksheets object to try to specify this as well and it still doesn't work.

I get the "GoalSeek method of Range object failed" message.

I have the application in manual calculation mode and used range
calculations to control the recalculation.

Can anybody offer any suggestions on what I might try? Thanks!


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com