I'm having a tough time speeding up a macro that runs through a very long sequence of steps. What's strange is when I switch excel to manual calculation, it flies through the macro in 4-5 seconds but when I switch the code to reflect this (i.e. put in xlCalculationManual in the first line of the code and xlCalculationAutomatic in the last line of the code) it is still really slow - does anyone know if it makes a difference where I put these commands in the code? Should I put them in multiple places within the code? Any ideas are greatly appreciated.