I recently bought a new (and much faster) computer and upgraded to Excell 2010. Running the exact same VBA application in Windows 7 takes signficantly longer to run than in Excel 2007.

I set Application.Calculation to manual and ScreenUpdating to false at the beginning of the code. It appears to slow down whenever the code tries to insert a new row into a sheet using cells(r,c).entirerow.insert. Perhaps Excel 2010 has a new setting that i need to change or add. What am I missing? Please help.

EdH