Excel VBA Delete after timer

  • I want to copy and paste a bunch of information from sheet "A" to sheet "B" and I want to delete the information from sheet "B" after a certain time frame. However, the macro should be able to run multiple times and subsequent information from sheet "A" should be pasted below the current information pasted on sheet "B" that has not been deleted yet. My current code can do this but I have a problem where by if I paste more information on sheet "B" the second time, the deleting function will mess up.




    Code
    Sub DelayMacro()
    
    
    Application.OnTime Now() + TimeValue("00:00:10"), "Delete"
    
    
    End Sub


    EDIT:
    Since no one has answered this on this site yet and I'm short of time, I asked this question on these sites too:
    http://www.vbaexpress.com/foru…timer&p=381929#post381929
    https://stackoverflow.com/ques…el-vba-delete-after-timer

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!