VBA: Named Argument Not Found error

[gers1978]

Ok, this code works fine:

detailsSheet.Cells.Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues

But conscious that using Selection can be slower, I tried:

detailsSheet.Cells.Copy
detailsSheet.PasteSpecial Paste:=xlPasteValues

This gives me a compile error, "named argument not found".

(details.Sheet is set elsewhere, on a user form, as a worksheet)

Also posted here:

http://www.ozgrid.com/forum/showthread.php?t=200128&p=772398#post772398

 

[BarryL]

detailsSheet.Cells.Copy
detailsSheet.Cells.PasteSpecial Paste:=xlPasteValues

 

[gers1978]

Hmm, seem to have solved it with:

detailsSheet.Range("A1").PasteSpecial Paste:=xlPasteValues

Could someone explain why this works but:

detailsSheet.PasteSpecial Paste:=xlPasteValues

doesn't? Thanks

 

[GTO]

Greetings:

Look at help topics for Range.PasteSpecial Method and Worksheet.PasteSpecial Method. You will see that there is no 'Paste:=' parameter for the worksheet method.

Hope that helps,

Mark

 

[My Aswer Is This]

Try this:

Sub Remove_Formulas()

With Sheets("detailsSheet").UsedRange
        .Value = .Value
    End With
End Sub