I am trying to get my VBA code to insert an active "Total" formula (ie like an autosum entry into an excel cell of "=Sum(D3:D56)") to sum a column of values, and update any subsequent changes to the values in that column. I can get the VBA code to sum the column and enter the result in the cell but it then does not change when a value in that cell changes.

I am a new VBA user so any help would be appreciated.