VBA-Code with Solver - Not working after copying worksheet

Hello!

I encountered following issue with my code, that includes a solver that should solve with the same parameters row by row.

It is perfectly operating in a worksheet. I copied the worksheet (incl. the start-button for the code) and in the new worksheet, the solver is operating, but the constraints are not. So the results are false.

I already checked that the active worksheet is the one I am working in.

Here's the code:

Please Login or Register  to view this content.

Any thoughts why the 2 lines with CellRef are only working in one worksheet?

Thanks, Chris