N
NFit
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 doesn’t 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?
resources until they are depleted and this often causes a crash. Even if the
program doesn’t 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?