I need to use Goalseek in my VBA code, but rather than seeking a goal for a target "CELL" in my spreadsheet, I need to seek a goal for a "VARIABLE" within my VBA code.
e.g. Rather than setting some target CELL to "A3", I need to set a target VARIABLE declared in my VBA code.
Same applies, of course, to the "By changing" field.
Is that even possible?
See Question&Answers more detail:os