| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste values only using destination:=
Is it possible to use the copy past destination one liner to paste values
only?? If so i would be very grateful for the relevant code Many thanks -- with kind regards Spike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy paste values only using destination:=
try
range("a1")=range("b2") -- Don Guillett SalesAid Software "Spike" wrote in message ... Is it possible to use the copy past destination one liner to paste values only?? If so i would be very grateful for the relevant code Many thanks -- with kind regards Spike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy paste values only using destination:=
Obvious i suppose really!!!
Sorry brain totally out of gear. Many thanks. -- with kind regards Spike "Don Guillett" wrote: try range("a1")=range("b2") -- Don Guillett SalesAid Software "Spike" wrote in message ... Is it possible to use the copy past destination one liner to paste values only?? If so i would be very grateful for the relevant code Many thanks -- with kind regards Spike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste up to values in last row | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy destination values | Excel Programming | |||
| user form to copy and paste from source to destination | Excel Programming | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
Linear Mode
