VBA - Copy Row with Todays Date...

[Quint6778]

I would like ALL rows to be copied if a column contains 'today's' date. Currently, the below code works - but is only copying the LAST row with a date of today in it. Anything standing out as odd in my code? (sorry in advance, im a rookie)

Please Login or Register  to view this content.

Thank you in advance!

[Takae]

You have not written the "Destination".

[Quint6778]

I didnt want a destination because i dont think its possible to paste it into an Outlook email(not as attachment).

This is part of other code that generates emails. After generating the email ill have the copy ready to go so its just a matter of "CTRL+V" & send. Minor...but something i wanted to attempt with the Date selection.

[Quint6778]

any suggestions and reason why it would only be copying the final row with that date?

[Takae]

It is not only copy the final row.
Your code runs perfectly but it says just copy to clipboard and loop and copy to clipboard and loop...
So, after loop,clipboard has been overwritten with new data by every loop.Therefore clipboard has only data of final row.

Do you want to past the copied data into each email? or all data(if IF statment = True) into an email?
If you want to past all data into an email, please test below code.

Please Login or Register  to view this content.

[Quint6778]

Excellent explanation there, thank you for realizing how that code was treating the clipboard because i was in left field. The plan is to copy ALL (todays date) rows into the same email, i will try the code above and let you know. Thank you again!