Loop Solver Macros

Hi,

I'm new to VBA or macros. I am trying to solve multiple cells in which the inputs also changes. Following is the recorded Macros.

Please Login or Register  to view this content.

I wanted the loop to change the values of D3 and G4 by assigning T3-T28 into D3 and U3-U28 into G4. Once the input is changed, I want to solve so that cell B2 minimum by setting B25>= B26 and B39<=B40. The variables that cells that are fixed are B2, B25, B26, B39, and B40 while the one that are changing are T3-T28 and U3-U28 which will be assigned into D3 and G4. I apologize if this isn't to clear.

I appreciate your help.

Thank you for your help. I'm still not sure on how to run the macros. So after I opened up the VBA window and edited the module, do I just need to run it? I tried to run but excel keep notifying me "Compile Error: Sub or Function Undefined". Is this because I have not called in the worksheet into the VBA? Thank you.

Thank very much for your help. This works. I appreciate your help.

Is there anyway that the macro program can include to approve to solve ("OK") in the cycle. I realized that I have to click ok for each cell that needed to be solved.

Try changin line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf