Are you asking to fix the macro or to recover the spreadsheet because you didn't have a backup?