Posted to microsoft.public.excel.programming

myBasic[_2_] myBasic[_2_] is offline

external usenet poster

Posts: 10

.Copy Destination:= .PasteSpecial ???

Hi Everybody,

Why the following statement can't run successfully,
----------
With ActiveSheet

.Range("A1").Copy Destination:=.Range("A4").PasteSpecial
paste:=xlPasteValues

End With
----------

I need to use the them together, Destination -- can let stay at a sheet,
PasteSpecial -- can only copy the value, not the color or border.

Any suggestion?

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
Using a PasteSpecial within a Destination:= line	drdavidge	Excel Worksheet Functions	0	July 13th 06 07:06 PM
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 09:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us