ActiveCell.Formula Help

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)

By: Brittany

Leave a Reply

Your email address will not be published. Required fields are marked *