I know about the screen updating trick, and I know the Disable Calculations. Which since messing with the Calculations disable code a couple days ago my whole excel program is autocalc off. So when I get it back on, the auto calc code will never go in my code again.
Are you sure you can't sort a sheet irregardless of it being selected?
Also, I need a way to get rid of the Blank Rows.