CLEAR COPY: after copying and pasting using VBA, area still

[itr674]

1. After I copy and paste with VBA the copied area is still highlighted--how do you clear the highlight within the code?

2. I get a message asking if I want to "replace the contents of the destination cells"--I have to answer yes 20 times---is there a way to not have that message come up?

Range("N14:BA14").Copy
For Each ce In Range("M15:M286")
If ce = "" Then Range(ce.Offset(, 1), ce.Offset(, 39)).PasteSpecial
Next ce

 

[Norie]

1. Application.CutCopyMode = False

2. Application.DisplayAlerts = False

 

[itr674]

Norie--thank you..