How come in the following the result is zero, instead of =Base? I am loading a value in the cell that is named "Base" after this runs.
ActiveCell.FormulaR1C1 = "=Base"
Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column - 1).End(xlUp).Offset(, 1)).Value = ActiveCell.Value
Is there a way to, when a value is added to AT7, a script like this run, and put them in as values instead of a formula?
Interested to both solutions. Please advise and thanks. -R-