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?
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?
Code:
Range("N14:BA14").Copy
For Each ce In Range("M15:M286")
If ce = "" Then Range(ce.Offset(, 1), ce.Offset(, 39)).PasteSpecial
Next ce