Excel Macro Find / Alter / Replace Function turn Subtotals into Sums

I have a spreadsheet that already has some macros that setup SUBTOTAL functions where I would like there to be SUM functions.

The code that creates the SUBTOTAL functions I believe is this...

Excel Formula:

Please Login or Register  to view this content.

There is one caveat, I would like to change the first Cell cited in the formula down by 1 Cell.

I would like: =SUBTOTAL(9,V2:V55)

To turn into: =SUM(V3:V55)

To be clear the above example was a static one, I would need to be able to do this dynamically to work with any range. It should always be in the same column if that helps.

Thanks in advance, I have found solutions for a simple find and replace, but not exactly sure how I move the cell range down 1 cell just for the first cell cited in the function.