Thread: Run-Time error'1004' PasteSpecial Method of Worksheet class failed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gj[_2_] gj[_2_] is offline
external usenet poster
  
Posts: 9
Default 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

Reply With QuoteReply With Quote