I have a macro, when triggered, it copies, then "pastes special" then copies that and "inserts cells below". The point of the double copy is to get the values, not the formula's when I insert below, its like a recorder.
The macro works fine but it is triggered when a condition is meet, such as cell a1 displaying a 6 rather than a 5. The cell may display the number 6 for 10 minutes prior to going back to number 5, resulting in my macro to run over and over again, maybe a 100 times within that 10 minutes, leaving me with loads extra records which i don't need.
I posted my macro below, Is there a way I can have my macro pause after completing its steps for like 1 minute. So basically continue to run for just 1 minute doing nothing, then end.
I know very little with MVB so if you could just help me with the modification to the code I would be very thankful.
AL
MY MACRO
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/15/2006 by Bob
'
'
Sheets("Sheet2").Select
Range("A5:L7").Select
Selection.Copy
Range("A9").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A8:L11").Select
Application.CutCopyMode = False
Selection.Copy
Rows("17:17").Select
Selection.Insert Shift:=xlDown
Range("A1").Select
End Sub
|
Similar Threads
