ExcelBanter - DataObject Error in Excel version 2002

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - DataObject Error in Excel version 2002 (https://www.excelbanter.com/excel-programming/349013-dataobject-error-excel-version-2002-a.html)

PT_VBA_GRRL

DataObject Error in Excel version 2002

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[_2_]

DataObject Error in Excel version 2002

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?

All times are GMT +1. The time now is 04:40 AM.