I have the following code for totaling a column.
The problem is it finds the previous total and places a new total just below it. What I need is to delete the old total and replace with the new total.
Code:
Dim LR As Long
With Sheets("inventory")
LR = .Range("e" & Rows.Count).End(xlUp).Row
.Range("e" & LR + 1).Value = WorksheetFunction.Sum(.Range("e1:e" & LR))
End With
The problem is it finds the previous total and places a new total just below it. What I need is to delete the old total and replace with the new total.