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

Hi,

Am Wed, 14 Sep 2016 12:54:09 +0100 schrieb Jooniper:

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

try in VBE:
Edit = Replace = Search = Current Project


Regards
Claus B.
--
Windows10
Office 2016

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

I suspect you need to redesign your project so the fiscal year is
located in 1 place only and accessed there by all macros using it!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus