Paste Special by VBA

[manoj_th]

Hi Sir,


Can u pls tell me that how to paste the value by using VBA in excel.

Eg: In the cell A5 there is a formula "=Sum(A2:A4), I want to copy and paste the answer in the format of VALUE in cell A6 by VBA code in a worksheet/workbook. Request you to help in this regard.

 

[Istiyak]

HI Manoj


Try the given code


Open excel > press alt+f11 > then paste the give code


Sub Manoj()

Range("A5").Select

Selection.Copy

Range("A6").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

End Sub


Any query plz let me know.


regards

istiyak

 

[manoj_th]

thanks