ExcelBanter - Run-Time error'1004' PasteSpecial Method of Worksheet class failed

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

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

- - Run-Time error'1004' PasteSpecial Method of Worksheet class failed (https://www.excelbanter.com/excel-programming/368812-run-time-error1004-pastespecial-method-worksheet-class-failed.html)

gj[_2_]

Run-Time error'1004' PasteSpecial Method of Worksheet class failed

ActiveSheet.PasteSpecial Format:="text", Link:=False
DisplatAsIcon:=False
Rows("1:15").Select
Selection.Delete:=xUp

Works 1st time, then fails

Also: How to clear clipboard with macro?

Thanks many times
gj

All times are GMT +1. The time now is 10:36 AM.