freddie mitchell
New Member
- Joined
- Apr 14, 2011
- Messages
- 43
Hello everyone,
I hope you can help me with this query. I'm using Excel 265.
I have a worksheet that has around 100 events and their respective dates listed in 2 separate columns. I'd like to create a code that will open the worksheet on the cell that closest matches today's date.
For example, if the next event is on the 31st October 2020, then the worksheet should open to this date.
So far my very limited VBA code generates a error because I rarely open the worksheet on the exact date that an event occurs.
I'd be very grateful if someone could help with this.
Thank you and apologies if this has already been covered, I didn't find a relevant thread when I looked earlier.
Freddie
I hope you can help me with this query. I'm using Excel 265.
I have a worksheet that has around 100 events and their respective dates listed in 2 separate columns. I'd like to create a code that will open the worksheet on the cell that closest matches today's date.
For example, if the next event is on the 31st October 2020, then the worksheet should open to this date.
So far my very limited VBA code generates a error because I rarely open the worksheet on the exact date that an event occurs.
I'd be very grateful if someone could help with this.
Thank you and apologies if this has already been covered, I didn't find a relevant thread when I looked earlier.
Freddie