Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goal Seek macro
Hi
I was using goal seek in a macro to find an interest rate. But the goal I am seeking changes so in my code I have ActiveCell.GoalSeek Goal:=X, ChangingCell:=Range("A3") Where "X" is set to Range("A1").value But this gives me a "Reference is not valid" error. Is there any way around this, so that I can assign the goal in a cell in the worksheet and have the macro calculate the interest rate using "goal seek" Thanks But this gives me an error. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goal Seek macro
Did you define x as a variable? (dim x...)
Did you select only one cell which to be the goal? "Jeff" wrote: Hi I was using goal seek in a macro to find an interest rate. But the goal I am seeking changes so in my code I have ActiveCell.GoalSeek Goal:=X, ChangingCell:=Range("A3") Where "X" is set to Range("A1").value But this gives me a "Reference is not valid" error. Is there any way around this, so that I can assign the goal in a cell in the worksheet and have the macro calculate the interest rate using "goal seek" Thanks But this gives me an error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal seek via macro? | Excel Discussion (Misc queries) | |||
Goal Seek in a Macro | Excel Discussion (Misc queries) | |||
Can I build 'goal seek' facility into a macro? | Excel Discussion (Misc queries) | |||
Goal Seek tool in a macro | Excel Discussion (Misc queries) | |||
Simple goal seek macro | Excel Programming |