VB for copy & paste values (not formula's)

  • Thread starter Thread starter Eager2Learn
  • Start date Start date
E

Eager2Learn

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
 
Try

ActiveCell.EntireRow.Copy

rng.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=Fals
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code does not error but no copy either 4
Advanced Filter Error - I cannot spot my Error 3
Excel VBA 1
Copy and paste entire line starting at cell W 5
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1
Copy/Paste program error 2
Formatting and copy or copy and formatting ?? 2
End process at last row of data 3

Back
Top