Thread: Copy range in macro using paste special values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Copy range in macro using paste special values
Rng2.Value = Rng1.Value


Gord Dibben MS Excel MVP

On Mon, 20 Aug 2007 10:32:01 -0700, 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

Reply With QuoteReply With Quote