Fix Excel Macro Compatibility

I have an older-version .xlsm workbook whose VBA macros no longer behave as expected in the current release of Microsoft 365. The odd behaviour appears only when I run one particular macro; everything else loads fine. The full macro code is available, so you can step through, debug and rewrite any deprecated functions or references that the newer Excel object model now handles differently.

Your task is to make that macro run flawlessly in the latest Office version, leaving the rest of the workbook untouched. A fixed fee of ₹500 is set aside for this quick repair.

Acceptance criteria
• Updated workbook opens and the target macro completes without errors or unexpected results in Office 365.
• You provide a brief change log outlining what was modified in the VBA editor.

I can supply the file immediately and will test your corrected version as soon as it is returned.