0

I want to copy the cell values only and not the formula which is calculating the value of the cell which i am coping

Range("V186").Select
Selection.Copy
Range("N215").Select
ActiveSheet.Paste

copying cell value with formula and showing #REF! instead of value

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
UUR
  • 1
  • `Range("N215").value = Range("V186").value` – GSerg Aug 23 '19 at 10:31
  • In addition to @GSerg, if you are wanting to do this for a larger range, you could use: `Range("V186").Copy` below, `Range("N125").PasteSpecial xlValues` – Dean Aug 23 '19 at 10:38
  • 1
    Generally you should avoid using `Select` where possible. Have a read of [this question](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba). – jsheeran Aug 23 '19 at 10:48

0 Answers0