Selection.Copy Destination:=
 

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

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

Selection.Copy Destination:=
 

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

--
Don Guillett
SalesAid Software

"Mike Fogleman" wrote in message
...
Can this be done and preserve the formatting of the Destination range?

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

Selection.Copy Destination:=
 

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
"Don Guillett" wrote in message
...
try
Selection.Copy
Sheets("Sheet1").Range("A3").pastespecial paste:=xlvalues

--
Don Guillett
SalesAid Software

"Mike Fogleman" wrote in message
...
Can this be done and preserve the formatting of the Destination range?

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

Selection.Copy Destination:=
 

Never mind, I had a brain fart... Range1.value=Range2.value
Duh
Mike
"Mike Fogleman" wrote in message
...
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
"Don Guillett" wrote in message
...
try
Selection.Copy
Sheets("Sheet1").Range("A3").pastespecial paste:=xlvalues

--
Don Guillett
SalesAid Software

"Mike Fogleman" wrote in message
...
Can this be done and preserve the formatting of the Destination range?

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