I'm using solver to find the optimal price by returning a margin of 0.
Because I need to repeat this for several hundred prices, I have been trying
to use either an unfixed target cell reference, or alternatively use a range
of target cells (e.g. a column). It won't let me do either of these. Is this
something that is addressed in later versions of Excel, or is there another
solution you can suggest?