clear clipboard

[helens0]

Can anyone help, I've searched the forum and can not find a solution!

Is there VBA code to clear the clipboard?

I'm copying data from one workbook, pasting it into another (master workbook) and closing the source workbook, then repeating for numerous workbooks...

However when running the code it asks before closing each source workbook if I want to save the info on the clipboard - I don't - but it interrupts the code and requires the user to click no each time.

Any assistance gratefully recieved.

Thanks

 

[HalfAce]

Hello helens0, welcome to the board.

Try the line:
Application.CutCopyMode = False
at the appropriate spot in your code.

 

[helens0]

Perfect

Thank you very much

Helen

 

[HalfAce]

You're very welcome.