Hi,
I have created the following code to use solver when a cell is updated by a formula. It works fine.
Is there a way I can make the solver function do this for another 50 rows directly below row 86 detailed above?Please Login or Register to view this content.
The formulas and cells will be the same but just a row down.
Is there a way I can make the macros run only when the cell for that row is modified. I am worried it will be a slow running worksheet if it is fired up eveytime a calculation is made.
Thanks in advance
Kyle
Bookmarks