can anyone advise how to use this solversolve option Showref:=. As far as I
can determine it takes a string argument - the name of a function,
'Showtrial' is the example used in the documentaion I can find anywhere.=.
However all my attempts to use it to take control of the solver using VBA (in
my case aiming to bypass the dialog box that appaers when the time limit on
Solver is exceed so that I don'yt have tomanually press the 'continue'
button) indicates an error in Excel - 'The formula you typed contains an
error' and subsequently I get the message 'Macro error at cell
[Solver.XLA]Excel4Functions!A18' Excel is 2002, with WinXp. Any help on why I
can't get this ShowRef:= option of solversolve to work would be very much
appreciated, thanks.