Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saxman
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

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
Q: copy/paste table from Word JIM.H. Excel Discussion (Misc queries) 0 November 5th 05 04:57 PM
copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes niz Excel Discussion (Misc queries) 1 October 14th 05 02:06 PM
ROUNDUP copy/paste and fill handle not working Jason Southco Excel Worksheet Functions 1 October 10th 05 05:41 PM
need to copy/paste formula w/o it changing Bonnie Excel Discussion (Misc queries) 4 March 10th 05 05:53 PM
Copy/paste Subtotals RichNYC Excel Worksheet Functions 3 November 3rd 04 07:58 AM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"