Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
.Copy Destination:= << Forget when PasteValues is desired
I'd like to establish a rule that doesn't seem to be spelled-out
as such after reveiwing some 50-60 Google.excel programming threads. ..Copy Destination:= works fine when you need to copy a range (that might include formulas) to another range and retain the formulas (relative-addressing applied) in the destination range. ..Copy Destination:= doesn't mix and should not be considered if you are at all interested in pasteing values. It just doesn't apply (one must use the .PasteSpecial (property) with the augumnet Paste(xlValues) instead.. Can someone confirm this? TIA, Jim May |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
.Copy Destination:= << Forget when PasteValues is desired
That is my experience.
IOW, this is invalid: * [a1].Copy Destination:=[a2], Paste:=xlPasteValues This works, but leaves a running border around the copy range: [a1].Copy: [a2].PasteSpecial Paste:=xlPasteValues (The lower example uses a colon as separator to puts two statements on the same line.) - David On Aug 12, 1:46 pm, Jim May wrote: I'd like to establish a rule that doesn't seem to be spelled-out as such after reveiwing some 50-60 Google.excel programming threads. .Copy Destination:= works fine when you need to copy a range (that might include formulas) to another range and retain the formulas (relative-addressing applied) in the destination range. .Copy Destination:= doesn't mix and should not be considered if you are at all interested in pasteing values. It just doesn't apply (one must use the .PasteSpecial (property) with the augumnet Paste(xlValues) instead.. Can someone confirm this? TIA, Jim May |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas do not copy to destination cells, but as existing totals | Excel Worksheet Functions | |||
Conditional formatting, pastevalues, clearcontents | Excel Discussion (Misc queries) | |||
VBA .copy destination | Excel Discussion (Misc queries) | |||
how can i unprotacted worksheet. i forget password | Excel Worksheet Functions | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |