Copy range in macro using paste special values

's Computer Specifications

Hi,

I have always copied a range by using the select cell. But then I learned a
really easy way to do this with Set

Set Rng1 = Sheets("...
Set Rng2 = Sheets("...

Rng1.copy Rng2

Ok is there a way to do this but only paste the values?

Thanks for your help

's Computer Specifications

rng1.copy
rng2.PasteSpecial xlpastevalues

"Jeff" wrote:

> Hi,
>
> I have always copied a range by using the select cell. But then I learned a
> really easy way to do this with Set
>
> Set Rng1 = Sheets("...
> Set Rng2 = Sheets("...
>
> Rng1.copy Rng2
>
> Ok is there a way to do this but only paste the values?
>
> Thanks for your help

's Computer Specifications

Rng2.Value = Rng1.Value

Gord Dibben MS Excel MVP

On Mon, 20 Aug 2007 10:32:01 -0700, Jeff <(E-Mail Removed)> wrote:

>Hi,
>
>I have always copied a range by using the select cell. But then I learned a
>really easy way to do this with Set
>
>Set Rng1 = Sheets("...
>Set Rng2 = Sheets("...
>
>Rng1.copy Rng2
>
>Ok is there a way to do this but only paste the values?
>
>Thanks for your help

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: range copy and paste special within macro	Jef Gorbach	Microsoft Excel Programming	0	9th Feb 2010 01:39 AM
Re: range copy and paste special within macro	Don Guillett	Microsoft Excel Programming	0	9th Feb 2010 12:42 AM
Macro for Copy Paste special Values	lj	Microsoft Excel Discussion	13	11th Feb 2009 05:08 AM
Macro to copy and paste special values	bobby	Microsoft Excel Programming	1	7th Nov 2005 08:06 AM
Macro to copy and paste special values	bobby	Microsoft Excel Programming	0	7th Nov 2005 05:45 AM