Try the routine I just posted as follow-up to Bill.

Regards,
Peter T

"NOPIK" wrote in message
...
What I need to do to replicate it on Vista?
I never get anything like this and want to avoid it.

Without endless loop (it's pointless), everything works.
Yes, Excel is busy so it can't update screen - but it is absolutely
normal and it stops after end of loop. No error messages from Vista.

On my system it depends on what else Vista is running.

For example, I have code that runs flawlessly under both XP and Vista
when nothing else is running on the machine. If I also run the
taskmanager (showing CPU usage) at the same time however, then the
program fails under Vista.

It seems to depend on whether Vista is switching among tasks in some
what that I don't understand, but I can see the effects of it.

Bill
----------------------------------------
On Wed, 1 Oct 2008 10:45:00 -0700 (PDT), NOPIK wrote:

Without endless loop (it's pointless), everything works.
Yes, Excel is busy so it can't update screen - but it is absolutely
normal and it stops after end of loop. No error messages from Vista.