I have a large number of data sets, and my code goes through each and runs solver on each. The macro works flawlessly on Excel for Windows. Upon looking into this problem it is a known one, yet there aren't any solid solutions to bypass/fix this issue.
What happens is the VBA macro runs, performing all of it's Copy/Paste etc. functions, but Solver does not run until all of the macro has completed. Since I want to Copy data, Paste data, run Solver, copy output, paste output, repeat, the fact that Solver isn't running until the end causes it to only perform it's iterations on one data set; the last one.
If anyone has any insight I would appreciate it very much.
As I said, this is Excel 2011 for Mac.
What happens is the VBA macro runs, performing all of it's Copy/Paste etc. functions, but Solver does not run until all of the macro has completed. Since I want to Copy data, Paste data, run Solver, copy output, paste output, repeat, the fact that Solver isn't running until the end causes it to only perform it's iterations on one data set; the last one.
If anyone has any insight I would appreciate it very much.
As I said, this is Excel 2011 for Mac.
