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,449
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,084,799
Messages
5,379,946
Members
401,633
Latest member
DinnerB0ne

Some videos you may like

This Week's Hot Topics

Top