Selection.Copy Destination:=

[Mike Fogleman]

Can this be done and preserve the formatting of the Destination range?

Selection.Copy Destination:= PasteSpecial Paste:=xlValues
=Sheets("Sheet1").Range("A3")

 

[Don Guillett]

try
Selection.Copy
Sheets("Sheet1").Range("A3").pastespecial paste:=xlvalues

 

[Mike Fogleman]

There is no other way to keep it out of the clipboard and preserve
formatting? I am trying to keep my code out of the clipboard for cleaner,
quicker execution.
Mike

 

[Mike Fogleman]

Never mind, I had a brain fart... Range1.value=Range2.value
Duh
Mike