Hi, I have a macro that I use to copy a range of cells from one sheet and paste to another. When I close the workbook I am told there is a large amount of data in the clipboard and do I want to save it. Also if I select the source worksheet the last range of cells are selected and the broken line is circling the cells. I am sure there is a code for terminating the copy function. Does anyone know what it is? Thamk you, ettool