Copy Range

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

I need to copy a range from one sheet to another and past values only.
This works but pastes formulas and all:
SourceRange.Copy DestRange

I need to paste values only but this doesn't work:
SourceRange.Copy DestRange.PasteSpecial(Paste:=xlPasteValues)

How do I do it?

Glen
 
Glen said:
I need to copy a range from one sheet to another and past values only.
This works but pastes formulas and all:
SourceRange.Copy DestRange

I need to paste values only but this doesn't work:
SourceRange.Copy DestRange.PasteSpecial(Paste:=xlPasteValues)

How do I do it?

Glen
Click to expand...
Range("A1:C3").Copy
Sheets("Sheet9").Range("M25").PasteSpecial Paste:=xlPasteValues

Alan Beban
 
break it into two lines

SourceRange.

Copy DestRange.PasteSpecial Paste:=xlPasteValues
 
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

VBA code for pasting links -- modifying RDB code for summary workbook 10
Copying a range to a separate excel database 1
Copy cell range to another sheet 3
Pasting problems 1
Copy over formula to specific cell 2
Trying to close Excel file nut get error msg 4
Copy to Next Blank Row 5
Arrays and Loops 3

Back
Top