Thread: xlPasteValues
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 xlPasteValues
Hi Dale

You can see here two examples
xlPasteValues and the Value property

http://www.rondebruin.nl/copy1.htm



--

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


"Dale" wrote in message ...
This works great to copy/paste from one sheet to another,
rng1.EntireRow.Copy Destination:=Worksheets("Hist").Cells(Rows.Count,
1).End(xlUp)(2)

What would the code be to copy/paste values ?


Reply With QuoteReply With Quote