I have a spreadsheet with 50 columns. Each column performs an identical calculation using Solver. Each column is independent of any other column (all data needed by perform the calculation and optimization using Solver is contained within the column). I have created a macro that performs the Solver calculation on one column. I want to be able to repeat this calculation on other columns. Ideally, I would like to have 2 cells in my spreadsheet that tell the macro to start the calculation on column M and end the calculation on column Z. Of course, I want to be able to change the entries of those two cells to start and end with any two columns I choose. I am not proficient in VBA programming. Existing macro to perform the calc in one column was done by recording the macro. Thanks.
