Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |