[agumonkey]

In VBA there's a command to toggle screen redrawing, isn't it exposed through COM ? very impactful on performance, although I too like to witness high speed visual feedback of automated processing. The social implications are surprising too.

[pge]

One of the first things i learned about writing VBA macros was to start every one with application.screenupdating = false. It was amazing how much of a performance hit the screen updating was.

[agumonkey]

I remember at least three "mandatory" statement to wrap any heavy script. Actually I don't remember them, just some fuzzy count.

ps: I don't know how Excel is structured these days but up until 2003 there was zero multicore code, and VBA is not the fastest system around, so any way you can trim the workload is good.