How to clear clip board from vba

[welchs101]

I am copying and pasting a large amount of data in this macro i am writing. I think it might be good to clear the clip board everynow and then in the program.

any idea on how to do this via vba?

[royUK]

Try this

Please Login or Register  to view this content.

[welchs101]

i have used this before...........but i did not realize this actually cleared the clip board.