Peter has attended:
Excel Intermediate course
Macros
After rolling a spreadsheet every month by saving a copy of the old one and deleting the old information the macro is getting slower and slower? What could be causing this?
RE: Macros
Macros tend to get slower if there is more data to deal with. Even though you have deleted all the old information, is there more information on the spreadsheet? Has anything else changed? Do you always access the sheet and complete the tasks on the same workstation?