Has this been tried?

Application.ScreenUpdating = False
Application.DisplayAlerts = False

at the beginning of eacg piece of code to execute.

HTH. Jim


"OldRod " wrote in message
...
Sorry to bump an old thread, but I'm having a similar problem.

On 2 machines, one desktop, one laptop, both running Excel 2000 under
Windows XP, both running same code.

One machine (desktop) the screenupdating is always TRUE, so the macro
takes forever to run and the screen flashes/flip constantly. On the
laptop however screenupdating works as expected.

Is there maybe an option setting in Excel that could be preventing the
screenupdating from working the same between two machines?

Or a setting in Windows that could be conflicting with it?


---
Message posted from http://www.ExcelForum.com/