Create a macro that incorporates a delay

Hi,

I've created a dashboard report in work that feeds from three data sources all held on separate tabs. To update the reports I refresh each tab individually through the use of a macro on each and manually refresh the related pivot tables that feed off them. It only takes me 5 mins to update the report but ideally i'd like the whole process undertaken through the click of a button. I tried to achieve this by creating a macro that refreshes the first set of data, then the second, then the third and then the pivot tables, but when I run it it appears to want to do it all at the same time which causes excel to crash. Can I insert a time delay between each data and pivot refresh so the process is a lot smoother and actually works? Each data refresh takes 30 secs max and the pivot refreshes are pretty much instantaneous so i'd only want a couple of seconds delay for these.

Thanks in advance,

Snook

To include waiting time of 10 secs pl add this code in your macro where ever required.

Please Login or Register  to view this content.