Find and copy row containing today's date

Hi, I found this macro on a post and modified it to my needs. It works on one worksheet but not another. The verbage is the same except the names of the worksheets and destination worksheets. It appears that for some reason the "find" function just isn't working on this one but it DOES work on another worksheet in the same workbook. Any ideas? Thanks for any help!

Please Login or Register  to view this content.

Hi aabrownell

Welcome to the Forum.

I don't see a "find" function in your code so I'm assuming you're referring to the if/then loop. Were it me, I'd check the formatting between the two sheets to see if they're the same; I'd look at the display in the Formula Bar to see if the display is the same between the two sheets.

Working with dates can get squirrelly in VBA.