Vba copy paste values

[gldurand]

Hi All,

I have the following VBA Code that copy/paste from 1 workbook to the other, but I want it to copy/past values

any ideas??

Dim wb1 As Workbook, wb2 As Workbook

Set wb1 = Workbooks("Master - CSAM Global Dashboard 2018.xlsm")
Set wb2 = Workbooks("2018 Major Outages 1.0.xlsm")

wb2.Sheets("Major Outage Tables").Range("B21:L35").Copy Destination:=wb1.Sheets("MO Tables RFO CAT0").Range("B3")
wb2.Sheets("Major Outage Tables (2)").Range("B1:H19").Copy Destination:=wb1.Sheets("MO Tables RFO CAT0").Range("B47")
wb2.Sheets("Major Outage Tables (3)").Range("B34:L44").Copy Destination:=wb1.Sheets("MO Tables RFO CAT0").Range("B20")
wb2.Sheets("Major Outage Tables (3)").Range("B47:K58").Copy Destination:=wb1.Sheets("MO Tables RFO CAT0").Range("B34")

 

[Fluff]

How about

Wb1.Sheets("MO Tables RFO CAT0").Range("B3:L17").Value = Wb2.Sheets("Major Outage Tables").Range("B21:L35").Value

Both ranges need to be the same size

 

[gldurand]

Thanks Fluff... all good..

 

[Fluff]

You're welcome