Code for finding most recent email with " " subject when multiple exist

Below is the code i am using to find an email with the subject "raw sales log" in my inbox and copy and paste it into another worksheet. It works fine, but when i have more than one email with the same subject, it gives me an error. I am looking to add some code that will look for the subject i have specified, but only find the most recent one, and ignore the others

Please Login or Register  to view this content.