Excel Macro for running solver

[kodamv]

Hi all,

I have a problem with a macro in Excel 2007. It invokes
solver and creates an answer report. Please find the VB
code for macro, below.

Please Login or Register  to view this content.

When I run this macro, i am getting an error "an unexpected
internal error occured,or available memory exhausted".
When I remove the SolverFinish statement from the macro, I don't
get this error.
Can you please help me using the SolverFinish function here - as I need to look at the report solver generates.

I greatly appreciate any help.

[shg]

Welcome to the forum, kodamv.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

[shg]

Thanks.

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[kodamv]

Great..Thanks for the help.

[shg]

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

[kodamv]

I have a follow-up question. Once I create the report with the above macro - I added some more tasks to the macro. It basically copies some cells from the report to a different sheet and deletes the answer report.

The code looks as below.

Please Login or Register  to view this content.

When I run this from view macros and run it - it runs without any error. But, when I assign this macro to a button and run it gives an error 'Visual Basic 400'.
Can you please help me understand what is going wrong?

Thanks a lot!

[shg]

You can simplify the code some:

Please Login or Register  to view this content.

What line does it error on?

[kodamv]

With the simplified code, it is working fine.
Thanks a lot for your help. I am setting the status of the thread to solved.