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