Hi Jeff

After the paste line add this line to clear the clipboard

Application.CutCopyMode = False



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jeff" wrote in message ...
Hi,

This might be a dumb question. I have a macro - it opens a workbook, copies
a range, pastes the range in the original workbook, then closes the workbook
that was opened in the first place.

It promps to save the clipboard - how do you turn this off?

Thanks for your help