| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlPasteValues
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
xlPasteValues
rng1.EntireRow.Copy
Worksheets("Hist").Cells(Rows.Count,1) _ .End(xlUp)(2).PasteSpecial xlValues -- Regards, Tom Ogilvy "Dale" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set Paste:=xlPasteValues for all paste operations? | Excel Programming | |||
| Ron de Bruin - Using PasteSpecial (xlPasteValues) instead of Copy | Excel Programming | |||
| Check if clipboard is empty before .PasteSpecial xlPasteValues | Excel Programming | |||
| ActiveCell.PasteSpecial (xlPasteValues) hangs program | Excel Programming | |||
Linear Mode
