Excel File Slowing Down after Macros Added

L

Lee

I am a newbie to VBA.

I notice that my excel file seems to be slowing down when saving after
adding some simple macros for sorting data.

Are there some guidlines to minimize the impact of Macros slowing down excel??
Like screenupdating=false etc.

Thanks in advance,
 
O

Otto Moehrbach

To answer your specific question, you can bracket your macro code with:
Application.ScreenUpdating = False
Application.ScreenUpdating = True
I hedge because there could be other reasons why things are slowing down but
you don't provide any details about what is happening when you save. HTH
Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top