macro stops and ends program and restarts Excel

[GoodmanJim]

I have a macro which works perfectly for one search and will display the information correctly. This macro is then cycled by another macro to view other matches for the same sort information which works correctly.

Problem is after (about 20 or more) cycles, the total program goes belly up and restarts Excel without the workbook with the macro.

Is there a way to stop with.

Thanks in advance for your help

 

[mikerickson]

Yes, there is a way.

If one knew the details of the problem, one could find a solution.

 

[GoodmanJim]

What details do you need?

 

[mikerickson]

What details do you need?

A detailed description of the goal of the search and copy macro.
The code that is crashing Excel.
Plus any details about data lay-out that aren't implicit in the code.
And any attempt(s) that have been made to correct the issue and the results of those attempts.

 

[GoodmanJim]

This will take a few days to get the information.
Thanks for your time

 

[mikerickson]

This might be a major project that is better suited to Consulting Services rather than to the forum.

 

[GoodmanJim]

The problem was the macro was using titles (CD titles)with periods in them in the database. Changed the titles in the database and it corrected the problem.
Thank you all for your help