Speeding up a macro

One quick suggestion:

You very rarely ever have to select an object to work with it...

http://www.tushar-mehta.com/excel/vb...rder/index.htm

Example:

Range("C2").Select
Selection.EntireColumn.Insert

Becomes:

Range("C2").EntireColumn.Insert

You can also research...

https://www.soa.org/News-and-Publica...s42-roper.aspx

or

https://www.techrepublic.com/blog/mi...-excel-macros/

or

http://datapigtechnologies.com/blog/...xcel-vba-code/


Also, it might be easier to get help if you post a small sample workbook with the code in the VBE.