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)

Participate now!

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