Macros crash Excel

[ioncila]

Hi
Here's a thing that occurs to me frequently.
Most of my Excel files have macros. All of them work fine everytime I make them run once.
However, if I make them run twice or more times, it will freeze Excel (not respond msg) that I have to close it and open again.

Is that a way to prevent that?
Or is it a software problem?

Thanks in advance.
Ioncila

[Bob Phillips]

Sounds like a problem with your code, or an environment problem.

Not enough information to say anything more more specific.

[Paul_Hossler]

One thing to try is to use Rob Bovey's very excellent code cleaner

http://www.appspro.com/Utilities/CodeCleaner.htm

It solves a lot of problems for me

Paul

[frank_m]

If your looping and changing any row heights or column widths I once had adding ActiveSheet.DisplayAutomaticPageBreaks = False to the sheet activate event solve that issue for me.

[ioncila]

Thanks for your suggestions.
I will try them and give you feedback

Ioncila