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?