Error 2042 with application.vlookup for date

I'm trying to lookup up a value in a table. The lookup range is A:E. Column A is a date; Column E is a number. I am not sure why the statement is not returning a value. Column A is formatted as a date. I have the variable myDateEnd declared as a date. When I step through the code I can see a value for myDateEnd and the same value is in the lookup table. I can't figure out why IdxValueEnd is not returning a value (I tried to declare as Long and as Variant but neither method helps). Thanks in advance for any comments.

Please Login or Register  to view this content.

Perhaps

Please Login or Register  to view this content.