Sub Causes Excel to Crash

I have a series of modules, each with one sub. At the end of one sub, it will call the next to start. I am having a problem with one specific sub in the middle, but I can't figure out why. Everytime it gets to this specific sub, Excel crashes and brings up a window that says, "Microsoft Office Excel is trying to recover your information..." This happens everytime, and the macro never completes. I didnt write the sub any different than the others, yet it is still the only one that fails. Any ideas on common things that may cause this to happen?



All suggestions are welcome.

Thanks for looking!

Thanks for your response. So a previous sub copies a table into the "REPORT" worksheet on this workbook. I then use the match function to identify columns within this table. I also add helper columns. After the helper columns are added, I then filter the table as needed. Columns are then copied over to a seperate worksheet within the workbook, which creates a report. I have various other subs like this one that create other reports within the workbook, but this is the only one that is causing Excel to crash.

Please Login or Register  to view this content.

So after stepping through one line at a time, it seems to be crashing at this line every time:

Please Login or Register  to view this content.

It's weird because if I drag the prompt to skip over it, then it doesnt crash. If i remove the line, it still crashes at that same spot... i dont get it. Does this help anyone understand what may be occurring?