ARPHA Preprints, doi: 10.3897/arphapreprints.e79014
Use of Worksheet events in Excel to save solver objective cell value from each iteration
Prasanth Sambaraju‡‡ Independent Researcher, Hyderabad, India
Corresponding author: Prasanth Sambaraju ( prashanth.kng1@gmail.com ) © Prasanth Sambaraju. This is an open access preprint distributed under the terms of the Creative Commons Attribution License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited. Citation:
Sambaraju P (2021) Use of Worksheet events in Excel to save solver objective cell value from each iteration. ARPHA Preprints. https://doi.org/10.3897/arphapreprints.e79014 |  |
Abstract
Solver is a Microsoft Excel add-in program which is used to find an optimal value for a formula in the objective cell. Solver accomplishes this either by maximizing, minimizing or setting the objective cell value to a specific value. The article presents the utility of in built worksheet events in Excel VBA to save the value of objective cell from each iteration when solver is used for optimization.
Keywords
Solver, Worksheet events, Iteration