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