Copy Range & Paste Only Values

I want to press a commandbutton and fillacrosssheets but I only want to fill the values, no formatting, no formulas.

The following code works, but carries over the formulas and values.
I tried changing xlFillWithContents constant but without success.


Private Sub CommandButton1_Click()
Dim msg As Integer
Dim ws As Variant

msg = MsgBox("You are about to copy over the existing cells in columns D through P of the Bill Of Materials. Do you want to continue?", vbYesNo + vbQuestion, "Paste Cells")

If msg = 6 Then
ws = Array("Bill of Materials-2", "Admin")
Sheets(ws).FillAcrossSheets _
Worksheets("Bill of Materials-2").Range("D20:BottomLineC"), Type:=xlFillWithContents
End If
If msg = 7 Then
Exit Sub
End If
Application.CutCopyMode = False
Range("A1").Select
End Sub