As far as I can see your only option to do so is by using a macro.
You can either run solver with a macro (not as difficult as it sounds) or you can use the fact that solver "understands" range names, still you need a macro
Right click on the sheet tab where you have your solver model and paste this code in the new window that opens. What this macro does is every time there is an input to cell B4 the value in B4 is added to the range starting at J3. Say that an input to B4 is 10 the you get a range called "ChngCells" going from J3 + 10 + 3 i.e. range "ChngCells" is defined as J3:J13
So you can write ChngCells in the solver box for "By Changing variable cells" and every time you enter a value in B4 the J3:J?? range is changed according to the B4 value.
Alf
Bookmarks