View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Free Up More Memory or Reduce the amount <emory used in Excel 2003

Disabling ScreenUpdating does not free up memory, except perhaps memory
associated with refreshing the display.

Ensure you release your objects and particularly large amounts of data in
variables (which do not otherwise go out of scope) when done. There's not
much to suggest without knowing anything about your code and what problems
you are experiencing.

Regards,
Peter T

"Rene''48" wrote in message
...
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'