J John Richards Apr 23, 2005 #1 Is it possible to incorporate Goal Seek (or Solver) into a spreadsheet so it will function without manual intervention?
Is it possible to incorporate Goal Seek (or Solver) into a spreadsheet so it will function without manual intervention?
B Bob Umlas Apr 23, 2005 #2 Sure -- using VBA: range("A1").GoalSeek goal:=10,Changingcell:=Range("B1") for example
J John Richards Apr 23, 2005 #3 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
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
