I have created a VBA routine that increases the size of a named range every 1 second. This named range provides the data for a graph. The intention was that, upon click of a button, the graph would slowly grow/complete itself and therefore provide a good effect in a presentation. However my VBA skills are not up to the task and approximately 75% of the time the animation does not work. Can anyone suggest a better way to incorporate the Sleep function into my VBA routine that would allow for a more effective outcome?