1) Initial thoughts are that Solver could be referenced by a keystroke
macro. If any of the parameters need to be set before hand they could
be taken from specific cells on the worksheet, that are predefined by a
normal macro. At least the keystroke macro would be a starting point to
the final solution

2) Could the paper size be set to custom in Word at 297mm x 410 mm
adjusting the margins to the same size they are in excel?


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=483809