Should you need something a little more accurate you might want to investigate the Timer function instead.
Alternatively, if you're feeling ambitious, you might consider using some Windows API functions to create incredibly accurate timers.
It's probably also worth changing the colour that we're using so that we can see when things have changed. This time you won't be able to see the macro carrying out its tasks; once the subroutine has finished the screen will update once at the end to show you the final result.
When you run the subroutine again you should now see the time taken in seconds displayed at the end of the procedure.
You should test this both with and without screen updating to determine how much faster your code runs.
Your results will vary depending on your computer's specifications and a range of other factors but you should certainly see an improvement in performance when screen updates are turned off.
Although the example above demonstrates the principle of the technique, it doesn't really reflect the type of code you're likely to write in the real world. The basic idea behind this example is to separate a list of films into separate worksheets based on each film's genre.
This is possible to do with the following types of charts created by SPC for Excel: To use this option, create the chart initially in an Excel workbook.