Copying values only

[Giordano Bruno]

Can someone remind me of the syntax for using copy with destination to copy only the value.

Range("Source").Copy Destination:=Range("Target")

Copies everything. I just want the value.

 

[tombrown]

2 lines of code (copying & pasting via the clipboard):

Range("source").Copy 
Range("destination").PasteSpecial xlPasteValues

Can probably be done all in one line .. but I dont know how

 

[Giordano Bruno]

Thanks tombrown.

I had an idea that it could be a one liner. May be I've got it wrong.

 

[Boller]

Provided that "Source" and "Target" are the same size and shape, and both consist of one area only :-

Range("Target") =Range("Source").Value

 

[Giordano Bruno]

Thanks Boller,

That's not the way I remember it, but it works perfectly. Once again, thankyou very much.