Excel 2010 Solver Macro

I have lost my Personal.xlsb file after "upgrading" to Win 10. I had recorded a macro years ago to invoke the Solver function repeatedly, using a relative reference to a cell rather than having to type in a value for the target value.  I suppose this could also be done with the Goal Seek function. I don't remember how I tricked it into using a relative reference but I do recall that I had to manually edit the target value in the initial recorded macro to an offset of -7 (seven columns to the left of the cell I was currently in. I attached an example, it should be a lot more clear than my explanation.
Solver-macro-example.xlsx