I have an excel spreadsheet with past and future dates(mm/dd/yyyy) in cells A9:A200. I want to have a macro to go to the cell closest to Todays date. All dates are in ascending order. Today() is in cell A2. I already know how to assign a macro to a button on my speadsheet, I just need the macro code.
Any help will be appreciated.
Maybe this?...
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hi,
By 'goto' do you mean you want the active cell to end up being the date cell closes to today? Suppose there are two dates both equidistant from today, which one would you want?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks