.formula value

  1. 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 =...

Some videos you may like

This Week's Hot Topics