runtime eror 1004

i created an add button so that the values key in will be put on a template excel spreadsheet....however when i exit and enter the program again and i try to change an input to overwrite the existing data.error:runtime eror 1004, application defined or object defined error....why?

Presumably you get the option to debug code.

Try that and come back.