Copy and paste values and formats

NDMDRB

Board Regular
Joined
Jun 20, 2016
Messages
128
Hello,

I have below piece of code in sub that copy a range and paste the selected in another range, it works fine but how can I make it to copy and paste the selected as values and formats

I tried to use ".Paste" but I got an error

Code:
  Sheet2.Range("Sales_List_All").Copy
  Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
 

Akuini

Well-known Member
Joined
Feb 1, 2016
Messages
2,383
Office Version
2013
Platform
Windows
Try:

Code:
Sheet2.Range("Sales_List_All").Copy
With Sheet2.Cells(Rows.count, 1).End(xlUp).Offset(1, 0)
  .PasteSpecial xlPasteValues
  .PasteSpecial xlPasteFormats
End With
 

Forum statistics

Threads
1,082,612
Messages
5,366,606
Members
400,906
Latest member
incanus

Some videos you may like

This Week's Hot Topics

Top