This spreadsheet was updated from MS Office 2012 to MS Office 2013. Now code I used before sheet1.cells(5,2) comes back and tell me application-defined or object defined error. So somewhere I lost a reference. could someone please tell me how to get It back. I cant seem to use sheet2.activate or anything referencing the sheets.