| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search files and copy with destination on file | Excel Discussion (Misc queries) | |||
| Range.Copy [Destination] should not use clipboard | Excel Discussion (Misc queries) | |||
| Using copy and destination formatting | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| VBA .copy destination | Excel Discussion (Misc queries) | |||
Linear Mode
