Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
Adding named range gives error "method range of object _Global failed " | Excel Programming | |||
VBA error 1004 "Select method of Range class failed" | Excel Programming | |||
Error 1004, "select method of range class failed" | Excel Programming | |||
"Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming |