When one of my Excel macros run, it scans rows and columns of data from
Sheet1 and copy selective data into Sheet2. It takes about 2 to 3 minutes to
finish the process. When it is running, I want to be able to switch to
another application, e.g. Word, or Powerpoint, to do something else, and have
my Excel macro still continue with its execution. However, it seems that the
Excel macro is "suspended" because my Sheet2 cells stop updating, and
updating resumes when I switch from the other application back to Microsoft
Excel. Is there any statement I can insert into my Excel macro so that it
continues to run when I switch to another task ?

Thank you.