Oooooops!
Just saw that the macro I modified post #3 did not correspond with the macro recorded in the uploaded file. A macro based on solver setting in the uploaded file should look like this:
Not sure I understand your solver settings. Range BD3:BD8 is set to binaries and the formula in range BD9 = SUM(BD3:BD8) and BD9 = 1
I set up a small loop to see how the cells to change behaved i.e. range BD3:BD8 and got the following values
Loop 1 BD4 = 1, all others 0 and sum BD9 = 1
Loop 2 BD3 = 1, all others 0 and sum BD9 = 1
Loop 3 BD4 = 1, all others 0 and sum BD9 = 1
Loop 4 BD4 = 1, all others 0 and sum BD9 = 1
Loop 5 BD4 = 1, all others 0 and sum BD9 = 1
Loop 6 BD4 = 1, all others 0 and sum BD9 = 1
Loop 7 BD4 = 1, all others 0 and sum BD9 = 1
So I do wonder do you really need solver?
Alf
Bookmarks