On Sunday, June 2, 2013 10:06:03 PM UTC-7, Howard wrote:
Thanks Garry, I believe this will do and both examples are useful.



Seems to work fine if the changes are made with a copy and paste en mass as opposed to typing in a few individual changes.



With the individual changes it seem to not copy all of them and errors out on this line:



For Each c In wksSource.Range(sTargetAddr)



I think what I am up against is that the expectation is that numerous changes at different intervals will occur in the range and when the On Time has expired the code gathers everything that has changed and does it copy and paste work.



Just to get my head clear on this, once a single change is made to the range the count down begins and when it expires, calls the copy macro and it does its work with whatever is in the range at that time.



Is that correct?



Howard

Just to add, paste special values will be need as there are formulas also.

Sorry, my overlook.

Howard