solver for multiple cells

Hi,

I have created the following code to use solver when a cell is updated by a formula. It works fine.

Please Login or Register  to view this content.

Is there a way I can make the solver function do this for another 50 rows directly below row 86 detailed above?

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

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here