I have an Excel file that was done in Excel 97-2003. It contains a macro. The macro runs fine in Excel 2010 but have now had to convert to Excel 2013 and the macro does not work. I am only a basic user on macros; can someone point me in the right direction? I get "Error 9". I tried to understand the debugger but I could not figure it out.
AllowFormattingColumns:=True, _ AllowFormattingRows:=True Sheets("Print-Send").Select Cells(counter, "D").Select ActiveCell.FormulaR1C1 = ("") Sheets(model).Select Sheets(model).Move _ After:=Workbooks("Compressed CPC.xls").Sheets(3) 'error here Range("B4").Select Selection.ClearComments Range("A8").Select Selection.ClearComments End If counter = counter + 1 Loop End With