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

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

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

copy paste values only using destination:=
 

Glad to help.
For an entire range use
range("a1:a5").value=range("b1:b5").value

--
Don Guillett
SalesAid Software

"Spike" wrote in message
...
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