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

  • Thread starter Thread starter gj
  • Start date Start date
G

gj

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PasteSpecial 3
"Run-time error '1004' 5
Help with error on PasteSpecial 2
PasteSpecial method of Range class failed Error 1004 8
Run Time error 1004 - Pastespecial method of range class failed. 3
Problems with a Run-time error of 1004.... 7
copying all charts as enhanced metafiles 7
PasteSpecial question 5

Back
Top