Hi all,

Is there any way to change the year in all macros in a spreadsheet, or do I have to do them all individually and manually?

I have a spreadsheet with 20 macros that are all looking at 2016 and we are just entering our 2017 financial year

Thanks,

June