Paste By Value

When using

Worksheets("Sheet1").Range("A5:A25").Copy Destination:=Worksheets("Sheet2").Range("A5")

is there a way to paste by Value into the destination cells? I believe that as is, the code above defaults to 'normal' paste mode (which also pastes formats).

How about formulas? Does the code shown above paste formulas behind cells in the source range into the destination range as well? Because I cannot afford for my code to paste formulas - I need the code to just paste by values, period!

Any help greatly appreciated. Thanks

Re: Paste By Value

Would this work? I mean, is it correct - syntaxically - speaking?

Worksheets("Sheet1").Range("A5:A25").Copy Destination:=Worksheets("Sheet2").Range("A5").PasteSpecial(xlPasteValues)