View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Spike Spike is offline
external usenet poster
 
Posts: 140
Default 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