-
Macro to loop through solver and post results to separate sheet
Hi guys, new to the forum and new to VBA, really appreciate any help possible.
I am trying to write a macro that will solve 5 scenarios, with information taken from the 'scenarios' sheet, with solver, and then post the results of each situation to a separate sheet.
It seems as if all my code works correctly, however, my code makes my macro loop through the five situations first, then post the result of the 5th situation 5 times, instead of posting the result of each situation as it is solved.
Not sure where I am going wrong.
P.S sorry if my code is written poorly, I'm learning slowly!
well three hours later I actually managed to solve the problem. I had for some reason put loops in my subs within the main loop. Seems simple now.
Transport.xlsm
Last edited by Roofasa; 08-03-2016 at 09:16 PM.
Reason: Solved it
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules