Automate Goal Seek?

  • Thread starter Thread starter John Richards
  • Start date Start date
J

John Richards

Is it possible to incorporate Goal Seek (or Solver) into a spreadsheet so it
will function without manual intervention?
 
Sure -- using VBA:
range("A1").GoalSeek goal:=10,Changingcell:=Range("B1")
for example
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver and Goal Seek-Tutorial 1
Goal seek via macro? 1
How to use goal seek on column 4
Optimization challenge 1
Correct cell value doesn't display 2
Goal Seek 1
Goal Seek Question 1
Button for goal seek?! 6

Back
Top