A macro that will copy and paste - question

[ericpny2]

i have a code that is copying and pasting a bunch of cells. once the code runs, it leaves the last copied cell still active. i need to deselect it somehow. i tried just putting this at the end of my code:

ActiveSheet.Range("A1").Select

but all that does is select the cell A1 and still leaves the previous cell highlighted and ready to be pasted

please help

 

[VoG]

Try

Application.CutCopyMode = False

 

[Comfy]

Application.CutCopyMode = False

 

[ericpny2]

Yes that is what i was looking for. Thanks guys