I'm trying to write a macro that will add to the formula already in an active cell. I'm having difficulty getting it to change the column that the formula references. The column always needs to be the one that the cell I'm working with is in, even the column reference to the other sheets. This cell won't always be added to the same row but will always reference the same rows.
Thanks
Code:
Sub Data_Add()
Dim Contents As String
Contents = ActiveCell.Formula
ActiveCell.Formula = Contents & "+((Totals!N$33+Totals!N$34+Totals!N$35)*Data!N$45*0.6)"
End Sub
Thanks