Macro Stopped working: Find not Finding

[yunesm]

I put together the following code to copy a set of values from a data entry screen into a summary table. The code worked perfectly for me for a long time. However, one day last week it just stopped working!

The code is no longer finding the date on the data entry screen on the summary table. I added some code to make sure it wasn't related to formatting and it seemed to fix it. But when I opened the file the next day it wasn't working again!!

So now I'm asking for some help. I've attached a test file and the code.

Any ideas would be greatly appreciated!!!

Please Login or Register  to view this content.

[Mordred]

Hi yunesm, you tried to declare List as a range. List is already predefined and can't be used that way. I've slightly modified your code.

Please Login or Register  to view this content.

Cheers

[yunesm]

Thanks Mordred! This works great. I appreciate the help!

[Mordred]

You're welcome!