Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste
I need to delay the the follwing copy/paste operations in a macro with a
time interval of 30 seconds. Is this possible? Sheets("Show").Select Application.CutCopyMode = False Selection.Copy Sheets("Chartdata").Select Range("B2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Show").Select Application.CutCopyMode = False Selection.Copy Sheets("Chartdata").Select Range("C2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False and so on...................The source data ("Show") changes every 30 secs. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Q: copy/paste table from Word | Excel Discussion (Misc queries) | |||
copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes | Excel Discussion (Misc queries) | |||
ROUNDUP copy/paste and fill handle not working | Excel Worksheet Functions | |||
need to copy/paste formula w/o it changing | Excel Discussion (Misc queries) | |||
Copy/paste Subtotals | Excel Worksheet Functions |