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,454
Office Version
365
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,085,026
Messages
5,381,266
Members
401,729
Latest member
azar3

Some videos you may like

This Week's Hot Topics

Top