Automate Goal Seek?

J

John Richards

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

Bob Umlas

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

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
 
Top