Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB for copy & paste values (not formula's)
Hello,
I am using the follow vb to copy a row from one sheet and paste t another. How can I alter this to only paste the values and not th formula's? Help. Dim rng As Range Set rng = Sheets("COMPLETED").Range("A" Rows.Count).End(xlUp).Offset(1, 0) ActiveCell.EntireRow.Copy Destination:=rng thanks! E2 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB for copy & paste values (not formula's)
Try
ActiveCell.EntireRow.Copy rng.PasteSpecial Paste:=xlValues, _ Operation:=xlNone, SkipBlanks:= _ False, Transpose:=Fals -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy / paste as values | New Users to Excel | |||
Copy and paste up to values in last row | Excel Discussion (Misc queries) | |||
copy, paste and transpose formula's into work sheets | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming |