No matter how much memory could be saved, I would always recommend using Long
(not integer) and Double (not Single).

I think that there's a better chance of stopping a worse error.

Gary Brown wrote:

Another thought is to be congnizant of the types of variables you are using.
Integers use less bytes than Long or Single which use less bytes than Double
or Currency which uses less bytes than Strings which use less bytes than
Variant, etc.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown

"Rene''48" wrote:

Hello Tech Suppport,

I am developing macros in Excel 2003.

I wanted to know if there is another command that will free up more memory
in the excel program without having to use Application.ScreenUpdating?

Thank you for your help.

Rene


--

Dave Peterson