I would like to autosum the the column charges from the last cell to cell 2 but i want to know if it is possible to add it to this code. since Charges can end up in any column.




    Set vFIND = Cells.Find("Charges", LookIn:=xlValues, LookAt:=xlPart)
    If Not vFIND Is Nothing Then
        vFIND.EntireColumn.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)"
    Set vFIND = Nothing
    End If