Thread: Modify this code to paste special, values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Modify this code to paste special, values
ActiveSheet.Range("b4:d33").Value = _
Sheets("1").Range("b4:d33").Value

--
Regards,
Tom Ogilvy

"Jonsson " wrote in message
...
Hi All,

I need to modify this code to paste only values.

Sheets("1").Range("b4:d33").Copy ActiveSheet.Range("b4:d33")

Any idea's?

//Thomas


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote