Posted to microsoft.public.excel.programming

external usenet poster

Posts: 9

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PasteSpecial Method of Range Class Failed Error	Brian C	Excel Programming	5	March 30th 06 08:01 PM
runtime error 1004 pastespecial method of range class failed	dreamz[_29_]	Excel Programming	5	February 3rd 06 02:57 PM
Run time error (Copy Method of Worksheet class failed)	Karthik Bhat - Bangalore	Excel Programming	5	January 3rd 06 11:43 AM
PasteSpecial method of Range class failed	windsor	Excel Programming	6	October 6th 05 10:16 PM
Run-time error '1004' PasteSpecial Method of Range Class Failed	Kevin G[_2_]	Excel Programming	1	February 3rd 04 05:01 AM

All times are GMT +1. The time now is 11:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us