xMIKExSMITHx
New Member
- Joined
- Jul 11, 2014
- Messages
- 45
Without getting too into the details, I have my 2023 forecast file macro which hides all the columns for 2024 forecasting(BG:BT), but since we are approaching 4th qtr, I need to keep the columns unhidden. My thought was to insert a few more lines of code that say if current month (I want use month instead of dates so I dont have to go and update the code each year to trigger the macro) is Aug, Sep, Oct, Nov, Dec, or Jan, unhide columns BG:BT on each sheet. I was trying to use the Application.OnTime function but hitting roadblocks on how to properly use it with only months and not dates, and also maybe thinking an "IF" function might be better suited for this task. Any help is appreciated.