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?