#1   Report Post  
Junior Member
 
Posts: 14
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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Amend all Macros

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
amend a VB code please Morgan Excel Discussion (Misc queries) 0 March 3rd 10 11:17 PM
Amend Formula colin Excel Discussion (Misc queries) 8 July 13th 09 12:36 PM
Amend year E[_2_] Excel Worksheet Functions 4 January 15th 09 03:51 PM
amend formula [email protected] Excel Discussion (Misc queries) 1 August 20th 08 05:02 AM
CAN ANYBODY PLEASE AMEND MY MACRO K[_2_] Excel Programming 0 April 22nd 08 04:19 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"