So I want to do something similar to what the Solver function does in excel: Maximize a target cell by changing variable cells. However, after every iteration I need a sub() to run that updates the cell to be maximized. I’m not quite sure what the best way to go about this is. But essentially I need to: 1) Update Variable Cells 2) Run macro (which updates the target cell) 3) Repeat 4) View Results and determine max Does this make any sense?? Thanks for any advice! I’ll keep plugging away to come up with something in the meantime.
If you have auto calculations on, you can just set the result cell to a formula based on the determinant cells. It will update automatically with each iteration. If you have auto calculations off, just say Cells(x, y) = SomeFunction(Cells(p, q), Cells(r, s), … ).
VBA is a joke.