I've recently been using Solver to pick out optimal baseball lineups provided their cost and how much I think they're worth. Solver runs fine, but my issue is when I attempt to run it the next day with a different number of players for each position I have to go into the Solver parameters box and reenter the named ranges for the changing cells. Is there any way to make Solver automatically notice the named ranges change in size?

Hopefully my question makes sense and thanks in advance for any help.