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

try
range("a1")=range("b2")

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Spike" <Spike@discussions.microsoft.com> wrote in message
news:82E53847-7C75-4BF0-8F3D-26F89DDDE65A@microsoft.com...
> 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

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
> dguillett1@austin.rr.com
> "Spike" <Spike@discussions.microsoft.com> wrote in message
> news:82E53847-7C75-4BF0-8F3D-26F89DDDE65A@microsoft.com...
> > 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
>
>
>

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Spike" <Spike@discussions.microsoft.com> wrote in message
news:5E47845A-3229-44A9-B07E-CAA06C59B780@microsoft.com...
> 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
>> dguillett1@austin.rr.com
>> "Spike" <Spike@discussions.microsoft.com> wrote in message
>> news:82E53847-7C75-4BF0-8F3D-26F89DDDE65A@microsoft.com...
>> > 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
>>
>>
>>