Solver macro not working when assigned to button

Hello!

I am having a problem where I am able to use my solver with the same constraints and variables when I just use it straight up, but when I record a macro and assign it to a button, it says that one of the cells in the worksheet became an error value when Solver tried certain value for Variable cells. I don't understand how the solver works when I run it but not when the recorded macro runs.

Any help would be appreciated

Pickle1

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I did it for you this time