Clearing the ClipBoard between Copies

[jtsains]

I have code that is copying data from two different programs and ultimately pasting it back into excel. When I copy from excel and paste the data into my other program, known in VBA as "session", then I copy from the relfection session and try to paste it to excel, some times it retains the values I copied from excel.

Is there a way to clear the clipboard after each paste code, so that the clipboard is clear each time I use the copy option?

 

[VoG]

Yes, use

Application.CutCopyMode=False

 

[jtsains]

Sorry guys, I found my own answer. Using Application.CutCopyMode = False after each paste, removed my clipboard information and allowed much more accurate copy/pasting for me. Thanks!!

 

[jtsains]

Thank you VoG! I didn't see your post before I sent my reply. I appreciate your support!!