Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Or what I hope people will find useful.
I have been having read and write memory errors while generating or trying to change captions for commandbuttons I have generated in a macro that loops so I can generate multiple commandbuttons From reading other threads in this forum I have set every variable used to either Nothing or Empty when finished with it and it did work. My macro's run like a dream. I have posted this as once you seem to get in the trap of getting a memory error, it is very difficult to pin point the problem. I will certainly ensure I empty all variable when finished with them in the future. Has anybody else got any useful must do's to prevent memory errors ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Memory errors | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
xls file size / memory errors | Excel Programming | |||
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming |