Thread: Copy/Paste Values Only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Copy/Paste Values Only
Try this Dan

DestRange1.PasteSpecial xlPasteValues, , False, False


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dan R." wrote in message ups.com...
How do I change this to paste the values only? If I
put .PasteSpecial(xlPasteValues) at the end of each it says 'Unable to
get the PasteSpecial property of the Range class'.

SourceRange1.Copy DestRange1
SourceRange2.Copy DestRange2

Thank You,
-- Dan

Reply With QuoteReply With Quote