The sum  is more of an example. Its not just suming. There's 3
formulas with cell  names:

=NPV(G63/12,$D$112:$D$183) (bob)
=SUM(C25:C111) (dan)
=SUM(D112:D183) (jim)

I need everymonth to be able to hit this macro  so it moves the
reference cell up one. So next month I will hit the macro and get
the formulas

=NPV(G63/12,$D$113:$D$183)
=SUM(C25:C112)
=SUM(D113:D183)

In bob, the D112 becomes 113, in Dan, C111 becomes 112, and in Jim
D112 becomes 113. It all basically moved the formulas one cell down.