VBA Code to check Date

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?

You will have to check if date exists before paste macro...Perhaps you should upload a sample file...

Yes I want check date before paste macro

Perhaps you should upload a sample file...

So that we can see the scenario and current code using to adapt...
To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.