Error 91 on finding date

Howdy!

I have a code to search a table and return the exchange rate, but it's not working.

Please Login or Register  to view this content.

I'm getting the error on the marked line. Any help is appreciated. Thanks.

First, you should never try and use the result of a Find operation without testing it was actually found. Second, what is fechadelcontrato? If it's a variable, where and how is it declared?

You test for Nothing:

Please Login or Register  to view this content.

Are the values in the range literal values, or the result of formulas? Do they include time parts, or are they just date values?

Just date values, not a result of a formula or anything. No time parts either.

Also, it is indeed returning nothing

Please Login or Register  to view this content.

If you use this instead of Find, does it find the value?

Please Login or Register  to view this content.

Sorry - change dayCount to be a Long, not Range.

And now I get a compiling error "object required"

Please Login or Register  to view this content.

Edit: My bad, forgot to delete the "Set" before. Now it works

You don't need the Is Nothing test now, but really we should still test to make sure it was foind, like this:

Please Login or Register  to view this content.