Excel Crashes on multiple saves

[Varun]

I have a macro which is like a form which gets and writes back to the
spreadsheet. The user can save the excel file from the tool itself. How ever
on multiple savings the excel sheet fails to open up saying the error "excel
has encountered a problem and needs to stop.. " .. Request you to help me in
understanding where i am going wrong?

 

[Dave Peterson]

I have no idea.

But I would put the code into a new test workbook and test the heck out of it.

If it works in that new workbook, then maybe the existing workbook is close to
being corrupted and needs to be rebuilt.

If it doesn't work, then maybe it's a problem with the code.