How to code dynamic variable cells in Excel Solver parameters? RRS feed

  • Question

  • Hi, Currently my solver aims to achieve my objective through minimizing a range of static 'variable cells'. My vba will filter certain cells/rows within this range - the aim is to re run the solver, without this data included under the 'variable cell' box in 'solver parameters'. How can I remove the need to change my parameters, each time I am including and excluding data from my range?

    #solver #excel #dynamic #cells #changingvariables

    • Edited by Jenn_Ale614 Wednesday, August 7, 2019 6:25 PM
    Wednesday, August 7, 2019 6:24 PM