Dynamic variable cells in Solver VBA macro

Hello,

I have a macro that runs Solver in Excel, it currently uses two different ranges as the variable cells. See the code below.

Please Login or Register  to view this content.

Instead of having an absolute reference to $C$7:$I$11, I would want to only select the rows of the range where K7:K11="Unlocked" (note that this is a separate column). Is it possible to achieve in a simple way? I have attempted creating a named range in Excel, but I have so far been unsuccessful. Maybe it's easier to solve within the macro, however my VBA skills are nonexistant.

Thankful for any help!