I am looking to use the Solver utility but want to present the end user with all possible solutions, not just one. In at least Excel 2003/7 there is an option to "Show Iteration Results". In VBA this sets the StepThru:=True. The problem is that it gives the user a prompt for every solution. I want to capture each possible solution in an array, or even write it back to the workbook in another location so that when the Solver completes I can present the user with all the solutions.
Has anyone encountered this before or have any advice?
Bookmarks