View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Amend all Macros

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