sparkytech
Board Regular
- Joined
- Mar 6, 2018
- Messages
- 96
- Office Version
- 365
- 2019
My Excel workbook contains multiple sheets which are all the same template other than the data in the cells. Each sheet has dates in B:11 to BC:11 which are the dates of each Monday for the year. I need to select (jump to) the cell containing the current week whenever each sheet is opened. Example: Today is 02.16.2021, so when I open each sheet it would need to jump to cell I:11.
I am still learning VBA and have no clue how to do this. Any help would be greatly appreciated!
I am still learning VBA and have no clue how to do this. Any help would be greatly appreciated!