Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Read through this and see if it answers your question:
http://support.microsoft.com/default...b;en-us;843304 How to create Visual Basic macros by using Excel Solver in Excel 97 -- Regards, Tom Ogilvy "googlesury" wrote in message ups.com... Brassman wrote: 1) Target.Row 2) On Error Resume Next -- Brassman ------------------------------------------------------------------------ Brassman's Profile: http://www.excelforum.com/member.php...o&userid=13290 View this thread: http://www.excelforum.com/showthread...hreadid=496069 I was trying to achieve the result in Item 2 above with the Solver module in VBA. However, I am not able to stop the Solver from displaying the Error handling Dialog box "Show trial solution" . I tried Placing the command "On Error Resume Next" at different places. Any suggestions? thanks in advance googlesury |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Questions should be simple please help | Excel Worksheet Functions | |||
VB simple Questions | Excel Programming | |||
VB simple questions | Excel Programming | |||
Two (probably) simple questions, but not for me.... | Excel Programming | |||
Several simple questions | Excel Programming |