Range PasteSpecial error

Posted to microsoft.public.excel.programming

Cantru

external usenet poster

Posts: 5

Range PasteSpecial error

Why does the following line doesn't work but, when you split it does?

Range("B8").Copy Range("DefYear").PasteSpecial (xlPasteValues)

Range("B8").Copy
Range("DefYear").PasteSpecial (xlPasteValues)

Whre DefYear is the name of a cell.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Run-time error '1004': PasteSpecial method of Range class failed	Conan Kelly	Excel Programming	1	August 7th 08 11:21 PM
PasteSpecial Method of Range Class Failed Error a Different Versio	SteveC	Excel Programming	10	February 16th 07 03:08 PM
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 '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 02:27 PM.

Menu

About Us