But sometimes, you don’t want to change the range to table, and the above method is not available in Excel 2003 or earlier version.
You don’t want to have to retype a table of numbers or recreate a graph in Power Point.
This means that the Excel screen can look like it has "gone crazy" while the macro is running.
One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.
The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.
The idea is to use the first line near the beginning of your macro, and then use the second line near the end.