![]() ![]() Is there a way of protecting my global variables and protecting the system memory allocated to Excel to prevent corruption? I'm running Win XP, on a P4 (3 GHz) with 1 gb memory. Apparently, Excel 97 is susceptible to some sort of memory leak. However, I get different results on the same puzzle, so it can't be a coding error (else the malfunction would always yield the same wrong results). I am definitely explicitly initializing all globals when macro starts. Largest global by far is Private boolArrCellValues(1 To 16, 1 To 16, 1 To 16) As Boolean, so I don't think I'm taxing memory storage. Fix is always to exit Excel completely and then re-open the spreadsheet. ![]() Although the solver normally works okay it periodically seems to malfunction. I've created a Sudoku solver using VBA in Excel 97. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |