Selection.Copy Destination:=

  • Thread starter Thread starter Mike Fogleman
  • Start date Start date
M

Mike Fogleman

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

Selection.Copy Destination:= PasteSpecial Paste:=xlValues
=Sheets("Sheet1").Range("A3")
 
try
Selection.Copy
Sheets("Sheet1").Range("A3").pastespecial paste:=xlvalues
 
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
 
Never mind, I had a brain fart... Range1.value=Range2.value
Duh
Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy value only...Copy Destination:=Cells(3, 2) 3
File Name changes with dates and Deleting Rows of Zeros 0
Copying Filtered Data from multiple worksheets 3
change all specific row references to next row available in fill downformula 2
Macro will copy formula instead of value 6
Tannspose and cycle 4
= Today()+1 into Sheet1, Sheet2, and Sheet3 2
PasteSpecial failed 2

Back
Top