.formula value

  1. G

    Copying a value from a formula, from one sheet to another

    Hello I tried to use this code to copy all the data from the column P6:P (last line) from the sheet "Original" and paste it on another sheet called "Test", well actually those data from the sheet "Original" are values, which are sums values by using FormulaR1C1. When I copy that on the sheet...
    • Gwhaou
    • Thread
    • #ref error .formula value copy & formula sheet to sheet vba
    • Replies: 5
    • Forum: Excel Questions
  2. D

    Value of a Formula in a Sheet Macro

    Hiya, I am trying to get a value of a formula to populate a cell when a change is made. I have it working so that the formula populates, but when another cell changes, it re-counts! What do I have to do to only insert the value? This the line in question: Target.Offset(0, 12).Formula =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top