Hi,
I have a workbook that I had been using for over a year with a very simple formatting macro in it. As of about two weeks ago, adding new data to the spreadsheet causes Excel to crash, rendering the workbook as corrupt. I have started fresh with a new workbook and re-recorded the macro at least a dozen times, and it will run once - maybe twice - and then, when new data is put into the workbook, it crashes. The weird thing is, I have anothe workbook that also has a simple formatting macro in it and that one runs fine. Both worksheets get the data from the same source, which is copied and pasted into the workbook with the macro.
Any ideas?????
Thanks!
Nancy