Paste By Value

  • When using

    Code
    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?

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!