Posted to microsoft.public.excel.programming

chemicals

external usenet poster

Posts: 25

Copy and PasteSpecial help

I have simple code:

Sheets("DW").Range("C15:BK15").Copy
Sheets("DW").Range("C11").PasteSpecial(xlValues)

I get the follwoing error:

Error 1004
Unable to get the PasteSpecial property of the Range class

What gives?

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
Copy Chart and PasteSpecial	PCLIVE	Charts and Charting in Excel	2	October 26th 06 03:01 PM
.Copy Destination:= .PasteSpecial ???	myBasic[_2_]	Excel Programming	2	November 12th 04 10:11 AM
Copy PasteSpecial	Rob van Gelder[_4_]	Excel Programming	1	July 28th 04 07:59 AM
Copy & PasteSpecial	Arthur[_3_]	Excel Programming	1	November 3rd 03 06:41 PM
Copy and pastespecial without formulas	Steven Cheng[_2_]	Excel Programming	2	July 26th 03 08:51 PM

All times are GMT +1. The time now is 02:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us