2 replies to this topic

[Qasem215]

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.

[MrShorty]

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.

[Qasem215]

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