speed up vba code within excel macro

**MOSHEBS** · 09-25-2011, 07:38 AM

good day

please how i speed up vba code within excel macro

thanks moshe

**mrice** · 09-25-2011, 07:50 AM

Two standard ways of doing this are to avoid using SELECT which appears frequently when a macro is recorded and Application.Screenupdating = False to remove the need for the application to spend time updating the screen.

**Andrew-R** · 09-25-2011, 07:55 AM

We see a lot of code posted here, which in addition to the issues above, is looping through a large number of cells trying to match a value. That can take a very long time - learn to use the .Find method.