Hi,

I have a macro that paste records in Column "A:K" and there is a DATE value in a column "A".
I need to add a macro that will check to ensure that column "A:A" do not have a DATE
which Macro Paste in it and have a warning message appear."DUPLICATE DATE" and macro stop

Can anyone help?