Hello,
in a sheet I have several dates either in the form of plugged-in values (could be in various formats as well, e.g. dd/mm/yy or dd/mm/yyyy or in the form of formulas.
I am looking for a macro that will take me directly to the cell with today's date.
If it is any help I tried the following but it only searches among plugged-in values, not formulas.
Thank you
Please Login or Register to view this content.
Actually, you are interested in the values of the cells (whether these are just written in or result of the formula), so change
intoPlease Login or Register to view this content.
Shall work, as long as there are dates (coukd be any format, but excel date) not just texts, which only look like a date.Please Login or Register to view this content.
Best Regards,
Kaper
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks