By the way, I tried some of the code others posted to empty the clipboard
still getting same error.

"PT_VBA_GRRL" wrote:

When I use Selection.SpecialCells(xlCellTypeVisible).Select to copy and paste
data I am getting an error when I am closing excel. It seems the clipboard
will not release the data and I get an object not found error.



So I am wondering, how do I release the data from the clipboard?