Jess1234556
New Member
- Joined
- Jan 26, 2025
- Messages
- 6
- Office Version
- 365
I'm relatively new to macros, but I've managed to create an automated spreadsheet with a code that transfers data (the macro is triggered with a button) from multiple tabs into one specific tab. We usually do this when the task has been completed, so we move all tasks to the completed tab.
My macro was working perfectly fine until about 40 minutes ago, when it suddenly stopped working.
To clarify, when I click on a row number, and press the button, the data is apparently transferred and then removed from the current tab. However, when I check the destination tab, the data has not been transferred, but up until not long ago, it transferred over 40 rows without issues.
I've tried several things:
My macro was working perfectly fine until about 40 minutes ago, when it suddenly stopped working.
To clarify, when I click on a row number, and press the button, the data is apparently transferred and then removed from the current tab. However, when I check the destination tab, the data has not been transferred, but up until not long ago, it transferred over 40 rows without issues.
I've tried several things:
- I've typed EnableEvents = true in the immediate window and also added it to the code.
- I've confirmed that all other macros in the workbook are still working fine.
- I've checked the destination tab and ranges and nothing has changed.