Formula to pastespecial

[shanan]

Hi,
I'm midst of copy a data from one cell(which contains formula) to another cell using VBA. However when i use .pastespecial option at macro it come as blank. any other coding that allows me to copy and paste the value from the cell which contains formula.?

Thanks for your assistance.

Shanan

 

[NARAYANK991]

Hi Shanan ,

If you just wish to copy a formula from one cell to another , you can use the .FormulaR1C1 property. An example would be :

          Set Sourcerng = Worksheets("Your sheet").Range("D8")
          Set Destrng = Worksheets("Another sheet").Range("J17")

          Destrng.FormulaR1C1 = Sourcerng.FormulaR1C1

Narayan