Hi Everyone,

I have a solver objective function that is getting calculated in a macro. I need to tie up these two solutions.

Objective function = max(cell)

this cell is populated using a macro

So, every time variable inputs change- macro should run to repopulate the column and then check if the cell value is maximized.

Please help if you have solved something similar.

Thanks,
Nupoor