trebor1956
Board Regular
- Joined
- Jul 2, 2015
- Messages
- 100
- Office Version
- 2013
- Platform
- Windows
Is there a way to change all references from 2023 to 2024 in all macros within a workbook at the same time?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Edit multiple macros
- Thread starter trebor1956
- Start date
jkpieterse
Well-known Member
- Joined
- Dec 3, 2007
- Messages
- 1,424
In the VBA Editor: Control+H
Tip: replace the hard-coded numbers with a public constant you declare at the top of one of the modules, next time all you need to change is the constant:
Tip: replace the hard-coded numbers with a public constant you declare at the top of one of the modules, next time all you need to change is the constant:
VBA Code:
'Top of any normal module
Public Const REPORTYEAR As Long = 2024
'First Sub is here
Upvote
0
Similar threads
- Question
