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.

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

    Since no one has answered this on this site yet and I'm short of time, I asked this question on these sites too:

Participate now!

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