Look at last pasted cell and if the same give me an error message box

I have made a macro that copies dates from 1 sheet and pastes them to another sheet. I do this everyday, with the dates changing. Right now I have it to look from bottom of the sheet up to the next blank cell and pastes the current dates. I want it to look at the last pasted cell and if the date is the same give me a message box error. Hope this makes sense.

Thanks
Jeremy

Hi JH, Welcome to the forum.

Take a second and read the FORUM RULES (link above in the menu bar), lots of great tips, and many enforced rules. Rule #1 - the thread title must concisely describe the problem.

So, while I write up an idea for you, EDIT that post above and correct the title... "Add to last Row only if date is different"... something like that.