We have an Excel 2003 spreadsheet that contains a macro. We are upgrading Office to 2010. When we convert the file, one of the macros generates a runtime 1004 error and when I open the debugger, The line 'Selection.insert Shift:=xlToRight' is highlighted. Why would this work in 2003 but not 2010, Is there a way to fix this? I know nearly nothing about macros and VBA. I have attached the code.