Macro Not Completing, No Errors

[Ataraxicatom]

Hello,

I created a sheet that pulls data from another sheet and sorts it. The macro activates when this sheet is opened. I had it working fine then I realized that it wasn't sorting items with a "J" in front of them. I wrote a little code to fix the problem:

Please Login or Register  to view this content.

After inserting that, towards the bottom of the macro, I noticed that it was not running. I don't know how much of my code is not running, because everything else seems to work fine.

I have been getting a graphical error after the code executes, but going to a different tab in the workbook and coming back showed that the right data was there. I have attached the workbook and commented out the "no save" and "refresh connections." I also removed the connection to the other sheet. Any help would be appreciated.

[Ataraxicatom]

I tested the code by stepping through every line and it runs just fine. When I execute the code in the manner I need to (when the sheet opens) it doesn't throw any errors, but it makes modifications to sheets that it shouldn't. Since I direct all of the code, I can't figure out why something would execute on the Input sheet if the code says:

Please Login or Register  to view this content.

I am perplexed. I moved each section into a sub and called them from the previous sub. The result is the same. If anyone could give me a few pointers, I would appreciate it.

[shg]

In this,

Please Login or Register  to view this content.

... thos red references refer to the active worksheet. What sheet should it refer to?