Help with writing VBA code to loop Solver

**yegor2000** · 08-06-2012, 01:27 PM

Hi all,

I'm relatively new to Excel VBA and using add-ins, but I've been trying to use solver to iterate multiple variables with a number of constraints until a satisfactory outcome is reached (see attached screenshot). ScreenHunter_02 Aug. 06 11.33.gif

While I can get the code to work for a single cell in row 298, I need to be able to copy the solver code down to each subsequent row ending at row 426. Since running solver manually takes too much time, could someone please show me how to write the proper VBA code? Any help would be greatly appreciated.

Thanks,

Yegor

**shg** · 08-06-2012, 01:29 PM

Maybe, if you post a workbook instead of a picture, and explain in context.

**yegor2000** · 08-06-2012, 05:37 PM

Originally Posted by shg

Maybe, if you post a workbook instead of a picture, and explain in context.

I took a stab at writing the code myself. The code runs to completion, but none of the values below line 298 are updating. What am I doing wrong?

Please Login or Register  to view this content.

**shg** · 08-06-2012, 06:11 PM

I think all that is equivalent to ...

Please Login or Register  to view this content.

What version of Excel are you using? It's not Excel 2003 as shown in your profile.

I have no suggestion without seeing the workbook.

---------- Post added at 05:11 PM ---------- Previous post was at 05:06 PM ----------

Maybe what you want is closer to this:

Please Login or Register  to view this content.

Help with writing VBA code to loop Solver

LinkBack

Thread Tools

Rate This Thread

Display

Help with writing VBA code to loop Solver

Re: Help with writing VBA code to loop Solver

Re: Help with writing VBA code to loop Solver

Re: Help with writing VBA code to loop Solver

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions