Press F9 to place a breakpoint in where it adds the first item, then press F8 to step thru it to see where it hangs up. Remove any On Error statements. They might be masking something also, especially if you have a Resume Next.