Hello,
I am having a problem, I want to automate solver for a specific problem,, however, I cannot understand how to use VBA and I have no programming skills.
Screenshot 2023-01-22 at 15.40.19.png
I want to find e1 and e2 so that eq.1 and eq.2 are equal to 0.
e1. 1 and eq. 2 are two specific equations that depend on e1 and e2.
I have found them manually, however, I will need it again!
Thank you!
Please see the hint in a yellow banner near the top of the page.
Solver probably can find the solution without any programming. It is just an issue of proper setting of a goal.
If not Solver alone, then: Yes, VBA could be used to run Solver several times (also with different setups) and iteratively find the final solution.
Best Regards,
Kaper
Hello,
Thank you for your reply,
Yes solver works however I have to repeat the process for every row, I was trying to find a solution for that.
For example a code I could run and tell Excel to solve x rows using solver automatically.
Do you know about any code or a way to build that code?
Thank you for the help,
Sure, you can use similar commands as shown for instance here: https://www.excelforum.com/excel-pro...worksheet.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks