Hi,

application.screenupdating = false is an instruction to excel not to update
the window. If your code crashes, or hits a bug then it will automatically be
turned back on.

Chip's API function is an instruction to the the computer, not just excel,
not to update the window. It's a lot stronger, but if you don't turn it off
(or you hit a bug before you turn it off) you're knackered, hence his
emphasis on calling it with parameter 0.


"Ray" wrote:

Thanks for all of the responses ... it's very much appreciated.

I implemented Sam's solution first, as it was the easiest ... and
worked perfectly.

Chip, your solution is intriguing -- could you please explain what the
functional difference (to end-user) is btw this solution and disabling
screen-updating?