My Macro does not find a simple date in a calendar sheet

Hello!
The problem is simple: I click on a button and some data gets saved in the macro to be filled in the cells below the date. The date is to be found in the "Tagebuch" Sheet aka a calendar. But somehow it does not work, even though I have today's date in that sheet.

Please Login or Register  to view this content.

I always get my error box instead of the success prompt. Today's date (10.11.2013 number type set to "date") was in range("k90") of my "Tagebuch" sheet, which is clearly in the search cell range.

Thanks for helping me!
Taktiker

Hello Taktiker,

It will be easier to sort this problem out using your workbook. Can you post a copy of it?

Hello Taktiker,

Here is the corrected search function. I know it is a pain to include all the find arguments but it needs to be done. The reason is most of the arguments retain their settings between calls. Since these arguments are system level and not VBA level, you can never be certain what searchs have been performed before yours.

Whren looking for Dates, the argument LookIn should be set to xlFormulas instead of xlValues. Some date functions are volatile an are compute when called. These will be missed if the search is set only to xlValues. The other problem with matching dates is a Date has a time component also. Generally, you want to ignore the time portion in the search. This is accomplished by setting the LookAt argument to xlPart instead of xlWhole.

Please Login or Register  to view this content.

Hello Taktiker,

I don't speak German and had to look this up. Hopefully, it is correct.

Du bist willkommen!