Hello, I'd like to loop solver in a way that it'll solve every row until a certain row is reached. I've recorded a simple macro where solver solves the first row. Can anyone guide me?
I know this isn't a chemical engineering question per say, but i am using it for a chemical engineering purpose.
|
0
Excel Vba Solver Loop
Started by Qasem215, Aug 19 2020 07:45 AM
2 replies to this topic
Share this topic:
#1
Posted 19 August 2020 - 07:45 AM
#2
Posted 19 August 2020 - 10:44 AM
From an Excel forum I frequent: https://www.excelfor...tml#post5240043
I also recommend this (https://peltiertech..../SolverVBA.html ) to make sure you get your Solver references and such set up so that VBA and Solver can talk to each other reliably.
#3
Posted 19 August 2020 - 12:18 PM
Thank you so much sir, i actually found a solution on YouTube, i wanted to plot equilibrium reaction temperature vs reaction extent, and using solver was the easiest way to do it not thinking of what kind of polynomial would get out of the equilibrium constant
Similar Topics
Hot Oil Loop / Heating Medium DesignStarted by Guest_Lyne_* , 30 Mar 2024 |
|
|
||
How To Switch 2 Aspen Hysys Simulations When Connected To ExcelStarted by Guest_nfbeusebio_* , 14 Nov 2023 |
|
|
||
Hydrocarbon Dew Point Control Using Propane Refrigeration Loop.Started by Guest_BabRafiq1_* , 10 Jul 2023 |
|
|
||
Proper Read Of A Simple Temperature Control LoopStarted by Guest_panagiotis_* , 01 May 2023 |
|
|
||
Excel Based Calculator For Fluid Bed DryersStarted by Guest_outcast_* , 15 Mar 2023 |
|
|