Jump to content



Featured Articles

Check out the latest featured articles.

File Library

Check out the latest downloads available in the File Library.

New Article

Product Viscosity vs. Shear

Featured File

Vertical Tank Selection

New Blog Entry

Low Flow in Pipes- posted in Ankur's blog

1

Excel Vba Solver Loop


2 replies to this topic
Share this topic:
| More

#1 Qasem215

Qasem215

    Junior Member

  • Members
  • 27 posts

Posted 19 August 2020 - 07:45 AM

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.

#2 MrShorty

MrShorty

    Gold Member

  • ChE Plus Subscriber
  • 476 posts

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 Qasem215

Qasem215

    Junior Member

  • Members
  • 27 posts

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