Hi,

I noticed that Excel 2007 (or VBA) hangs on a long-during VBA script when I switch focus between the VBA editor window and the Excel window.


I've written a small Sub to delete rows containing strings having a substring matching the row's above. The worksheet contains about 135,000 rows.

Just want to mention BTW that Excel takes about 1 sec. to delete 10 rows, which is incredibly slow!


While my script executed, just out of curiosity I wanted to switch to the Excel window to see how far it got. From that moment on both, Excel and VBA window, hung. I can't even pause anymore. I can't tell if my script still is running or if it hangs as well.

To me this seems to be a bug. So I'd like to know if anyone can reproduce this behaviour so I can open an issue with MS.

TIA,
Axel Dahmen