Giordano Bruno
Well-known Member
- Joined
- Jan 7, 2007
- Messages
- 1,341
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.
Range("Source").Copy Destination:=Range("Target")
Copies everything. I just want the value.