Are you sure you need VBA for this? There is a way to sum  to the
cell above which keeps correct range references even after inserting a cell.
Then instead of BOB you could say =Cell where cell  is the one doing the
summing.