An Excel Visual Basic 6.5 program that does curve fitting uses system
resources until they are depleted and this often causes a crash. Even if the
program doesnt crash and returns reasonable data, I get the message €œNot
enough system resources to display completely€� when the program ends (and
reactivating the screen). Thinking that subroutines must be creating new
locations for variables or ranges with each subroutine call and not releasing
the resources when done I have moved all code to one module and all dimension
statements to beginning of the module. No improvement. Similarly, I moved
all Set statement out of the subroutines and into the main program. Neither
of these changes had an effect. Where else can I look for the problem?

Eliminating copy and paste code that was written by the Macro Recorder
eliminated the problem.

"NFit" wrote:

An Excel Visual Basic 6.5 program that does curve fitting uses system
resources until they are depleted and this often causes a crash. Even if the
program doesnt crash and returns reasonable data, I get the message €œNot
enough system resources to display completely€� when the program ends (and
reactivating the screen). Thinking that subroutines must be creating new
locations for variables or ranges with each subroutine call and not releasing
the resources when done I have moved all code to one module and all dimension
statements to beginning of the module. No improvement. Similarly, I moved
all Set statement out of the subroutines and into the main program. Neither
of these changes had an effect. Where else can I look for the problem?