I currently need a help to fix the code below.

SetCell:="$M$30", MaxMinVal:=2, Valueof:="0", ByChange:="$D$4:$D$28"

The error was compile error: syntax error.

  • 1
    You didn't even spend the time to spellcheck the error message. It's unclear what your code should be doing. As it is, it just seems to be a number of assignments. What have you actually tried to fix it yourself? – Seth Feb 6 '18 at 11:36

Excel never allows the Solver to use more than one executing parameters as you have used,

SetCell:="$M$30", MaxMinVal:=2, Valueof:="0", ByChange:="$D$4:$D$28".

Your syntax should be either with MaxMinVal or Valueof like,,

SetCell:="$M$30", Valueof:="0", ByChange:="$D$4:$D$28".


SetCell:="$M$30", MaxMinVal:=2, ByChange:="$D$4:$D$28"

NB: You need to decide which one is required.

Hope this help you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.