1

I've read that .Select statements force Excel to display each of those events on the screen and slow Macros considerably.

I'd like to speed up some old Macros that were written with record Macro methods and have many .Select statements.

Would Application.ScreenUpdating = False eliminate the time wasted displaying the .Select events?

Thanks in advance for any advice.

Moosli
  • 3,140
  • 2
  • 19
  • 45
Rich King of Angmar
  • 33
  • 3
  • You better avoid the often superfluous use of `.select` to optimize performance. – user1016274 Sep 03 '17 at 18:27
  • @pnuts The macro moved much faster and there were literally hundreds of .Select statements it had to plow through. Is it that simple to fix the time wasted? Or are the .Select statements still wasting time as they operate out of sight? At this point I don't think anyone who uses the macro will complain haha but I'd like to know to grow my skills. – Rich King of Angmar Sep 03 '17 at 18:31
  • one way to grow your skills is to eliminate the .select statements from the code – jsotola Sep 03 '17 at 19:19

1 Answers1

3

Of curse it would speed up your old Macros,but i would be better to change to code and avoid the .Select Statment. Because there is no need for Example to Select a Cell and then write to the Cell. It's more efficent to write directly to the cell.

Take a look at this entrys. They will give you help optimizingyour VBA Code.

Optimizing VBA macro

How to prevent a macro from freezing / turning white the Excel window?

How to avoid using Select in Excel VBA

Moosli
  • 3,140
  • 2
  • 19
  • 45