Posted to microsoft.public.excel.programming

Ming[_2_]

external usenet poster

Posts: 14

How can I control the macro's running time?

I create one macro to grad the updated info and paste it to another spread.
then thing is it will take a while for the data update. so is there anyway to
control the macro's running time. i.e. after it excute some of the code, what
kind of code could halt the macro for 1 minute then keep running again.

thanks a lot for your help.

Ming

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
running macro's in Excel 2007	Texas Tonie[_2_]	Excel Worksheet Functions	0	May 4th 09 07:07 PM
Running XY chart labeller using a macro's parameters and arguments.	Hari Prasadh	Charts and Charting in Excel	1	July 12th 05 05:00 PM
Why do i have to re-assign macro's all the time	Simon Lloyd[_492_]	Excel Programming	4	June 22nd 04 07:19 PM
Assigning Macro's to control buttons.	catdataman	Excel Programming	3	December 23rd 03 05:16 PM
shortcut key not not running macro's all of a sudden	Todd	Excel Programming	1	November 11th 03 08:19 PM

All times are GMT +1. The time now is 05:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us