Jooniper

Junior Member

Posts: 14

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 05:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us