Friday, August 8, 2014

Excel Solver Error Message

Error messages really need to be formulated with care. I am already confused my code does not work and I would like to see a message that clearly states what is wrong and what I should do to remedy the situation.

A counter example is here:

Two Excel Solver bugs in two lines!! More info on the first one:

Just want to make a few quick plots:

Update: fixed by coding the number as a string in the variant. An alternative fix is shown here. Both are not obvious (to me).

1 comment:

  1. Debugging is definitely the worst thing when coding macros in Excel. :-)