Typically on an excel sheet we could apply a formula (macro) down a column by using fill-down. For most purposes, it is fast and convenient with most of the inline macros in excel. Recently I have created my own macro and it seems that for each row it takes more than I am happy with. My problem will eventually involve more than a thousand rows and I am starting to worry about excessive non-responsiveness if I let the user fill down a column of a thousand items.

If I have to program through an iterative process I could always stick in a DoEvents at least to let the system be responsive. However, filling down a column for each row to be processed by my own defined macro the control is no longer up to me. Is there a trick to make sure the filling down would not tie down the whole sheet for an inordinate amount of time?

Perhaps some way to put all these thousands macro processing to background process(es) ?