You appear to have commented out the line that turns off screenupdating. I suggest you uncomment that line and also set calculation to manual at the start and back to automatic at the end. Furthermore all that selecting is unnecessary - you can just manipulate the ranges directly.