RE: Macro with column delete running very slowly

Tech-Archive recommends: Speed Up your PC by fixing your registry

Deleted xlShift:= ToLeft and also set calculation to manual. No change macro
is still very slow and definitely when it reaches this point.


"JLGWhiz" wrote:

Forgot to mention that if you set calcultion to manual, it will help speed
things up a bit.

"Code Numpty" wrote:

I have a file that runs a macro to tidy up a file and remove confidential
information and lookups. The macro is taking more than 5 minutes to run. When
I use F8 in debug the line of code that seems to be taking the time is this.
-------------------------------------------------------------------------
Columns("E").Delete Shift:=xlToLeft
-------------------------------------------------------------------------
I am wondering if this is because the range A1;F1 is merged into one cell.

If this is the case, can anyone offer any solution to this problem?
.