Pause a Macro call without stopping sheet cell changes

  • The code below is in a module and called from worksheet code. It delays a copy and paste from Sheet1 to Sheet2 by 4 seconds when triggered. However during that 4 seconds, the macro prevents data being updated on Sheet1 from an external feed, so when the copy is pasted its 4 seconds old data. Is their a way, once the Sub Copy_Race is called, to delay the execution by 4 seconds but not affect the data updates and paste the current (after 4 secs) data?
    I knew Application.Now and Sleep froze the data, but was assured this method didn't?

Participate now!

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