I wote a VBA script in MS Excel to perform a custom curve fit. The program became quiet lengthy and recently I encountered error messages that the Solver Add in experienced an error or is low in memory.
I tested the program on different computers with different amounts of memory (ranging from 128 - 750 MB) and it seems that the physical amount of memory is not the limiting factor or causing the problem.
Has anybody here experienced that VBA can't execute code when the macro becomes too long?
Any help is appreciated.
I tested the program on different computers with different amounts of memory (ranging from 128 - 750 MB) and it seems that the physical amount of memory is not the limiting factor or causing the problem.
Has anybody here experienced that VBA can't execute code when the macro becomes too long?
Any help is appreciated.