ExcelBanter - Copy Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy Range (https://www.excelbanter.com/excel-programming/316712-copy-range.html)

Glen Mettler[_4_]

Copy Range

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

Alan Beban[_2_]

Copy Range

Glen Mettler wrote:
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

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

Alan Beban

Tom Ogilvy

Copy Range

break it into two lines

SourceRange.

Copy DestRange.PasteSpecial Paste:=xlPasteValues

--
Regards,
Tom Ogilvy

"Glen Mettler" wrote in message
...
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

All times are GMT +1. The time now is 08:52 PM.