Automate Goal Seek?

[John Richards]

Is it possible to incorporate Goal Seek (or Solver) into a spreadsheet so it
will function without manual intervention?

[Bob Umlas]

Sure -- using VBA:
range("A1").GoalSeek goal:=10,Changingcell:=Range("B1")
for example

"John Richards" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to incorporate Goal Seek (or Solver) into a spreadsheet so
> it will function without manual intervention?
>

[John Richards]

I suspected that I could do it with VBA but unfortunately I'm not familiar
with how to use it. Guess I should make an effort to learn it.

Thanks for the help
John



"Bob Umlas" <[email protected]> wrote in message
news:%[email protected]...
> Sure -- using VBA:
> range("A1").GoalSeek goal:=10,Changingcell:=Range("B1")
> for example
>
> "John Richards" <[email protected]> wrote in message
> news:[email protected]...
>> Is it possible to incorporate Goal Seek (or Solver) into a spreadsheet so
>> it will function without manual intervention?
>>
>
>