LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Useful Comment Concerning Memory Read/Write Errors

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Memory errors falcios Excel Discussion (Misc queries) 1 February 12th 07 11:34 AM
How can a file be converted from Read-Only to Read/Write Jim in Apopka Excel Discussion (Misc queries) 2 November 19th 05 04:59 PM
sumproduct causing memory errors? dave Excel Worksheet Functions 1 March 3rd 05 09:31 AM
xls file size / memory errors Stuart Bazzard Excel Programming 2 April 26th 04 11:28 AM
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc Angus Comber[_2_] Excel Programming 1 November 7th 03 01:18 PM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"