I am trying to write a piece of code that ultimately will display a formula in a cell of two cell locations.
The below code simply pastes the value in the cell instead of the formula. Is there a way to have the formula posted instead?
Cells(LR + 10, MCol2).Select
ActiveCell.FormulaR1C1 = Cells(LR + 10, MCol2) – Cells(RRR – 8, MCol2)