DataObject Error in Excel version 2002

[PT_VBA_GRRL]

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?

[PT_VBA_GRRL]

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?
>