If a error appears when you run a macro that has worked in the past, some part of the macro code no longer makes sense to excel. s

If a run-time error appears when you run a macro that has worked in the past, some part of the macro code no longer makes sense to excel, ehere run-time denotes  the time during which a program is running
This error occurs while the program is running.
Running out of memorywill results in  a run-time error.

Iwould try the first option, first then if that didn't work i would try the last option.

Ido that