I have a formula that I found that simulates the AutoSum button in VBA. ActiveCell.Formula = "=Sum(" & Range(ActiveCell.Offset(-1, 0), ActiveCell.Offset(-1, 0).End(xlUp)).Address & ")"
and I would like a vba code to add this formula or perform the autosum function in each cell in the range that contains the word "sum".
I'm not sure how to write the macro to do this. Any help is appreciated.