Hello Everyone,
Using Excel 2010

I have a workbook that copies certain cells from sheet J1 (which are colored and have formulas) and paste them into cells in sheet Jan01. The code works but I need to have the pasted cells pasted as values. Appreciate any help adjusting the code to make them pasted cells. Thanks.
Mike

Sub Test()
    Application.ScreenUpdating = False
    With Sheets("J1")
        .Range("A2:A3").Copy Sheets("Jan01").Range("O12:O13")
        .Range("B2:B3").Copy Sheets("Jan01").Range("Q12:Q13")
        .Range("D2:D3").Copy Sheets("Jan01").Range("O16:O17")
        .Range("E2:E3").Copy Sheets("Jan01").Range("Q16:Q17")
         End With
End Sub