Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delay copy & paste of data until web query refreshes?
You can also put a loop until it finds data in Range("E10:N10")..
If this post helps click Yes --------------- Jacob Skaria "CM4@FL" wrote: I need to delay copying my data in cells E10:N:10 while my web query completely refreshes, after the refresh is complete then can I copy the data. Can anyone help me with the delay function? Range("B4:C4").Select Selection.Copy Range("E4").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveWorkbook.RefreshAll ********* NEED A DELAY FUNCTION HERE ********* Range("E10:N10").Select Selection.Copy Range("E47").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy chart delay (musa.biralo query) | Excel Programming | |||
Copy/Paste in Excel Delay | Links and Linking in Excel | |||
"New Web Query" always refreshes data from website (3 times) | Excel Worksheet Functions | |||
Simple question: How to get web query to NOT overwrite data when it refreshes? | Excel Programming | |||
Combo Box value changing when query refreshes | Excel Programming |