Hope this is the right forum to be asking this in...I have an Excel workbook that contains four macros created with the built in recorder in Excel. The macros are all the same except for which of four sheets they perform their actions on. Basically what the macros do is add a row to Sheet2, go back to Sheet1 and copy a row of data, return to Sheet2 and paste that data into the row that was added, write some formulas in a couple of empty cells in that row, and then return to Sheet1.
The only thing that changes between the macros is if it goes to Sheet2, Sheet3, Sheet4, or Sheet5 (depending which macro is run). Three of them work perfectly and have continued to work even after the problem one started crashing Excel with the error message "run-time error '-2147417848 (80010108)': method 'formular1c1' of object 'range' failed".
My first thought is that the issue was because the sheet associated with the failing macro has over twice as many rows of data as the other sheets, but I used their macros to add the same number of rows to their associated sheets, and even after adding more rows than are in the sheet associated with the problem macro, they continued to function.
Ever since this error message started coming up every time I use that macro, anything I try doing that uses that data sheet crashes Excel... so I guess my question is, is the problem in my macro or is that sheet corrupt? If it is the sheet that is corrupt, any suggestions on how I might save the data entered into it without accidentally copying whatever is corrupt to the new version? Or if the macro is the issue, what should I post in the VB forum to assist someone in hopefully helping me figure out how to fix it!