Posted to microsoft.public.excel.programming

Matt Cromer[_2_] Matt Cromer[_2_] is offline

external usenet poster

Posts: 1

ActiveWorkbook.RefreshAll

I would like to gve the RefreshAll 5 seconds to complete before performing
the next actions. Is this possible?

Thanks

ActiveWorkbook.RefreshAll

Sheets("Data").Select
Sheets("Data").Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

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
ActiveWorkbook.RefreshAll	teepee[_3_]	Excel Discussion (Misc queries)	0	November 11th 08 02:11 PM
ActiveWorkbook.RefreshAll	nc	Excel Discussion (Misc queries)	0	March 21st 06 10:50 AM
ActiveWorkbook.RefreshAll	toosie	Excel Programming	1	February 16th 05 09:55 AM
RefreshAll Data with VBA	JasonSelf[_4_]	Excel Programming	2	January 25th 04 09:52 PM
ActiveWorkbook.RefreshAll	Mark[_22_]	Excel Programming	0	October 15th 03 02:22 AM

All times are GMT +1. The time now is 10:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us