Excel Macro Find / Alter / Replace Function

[DarthDiggler]

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 creats the SUBTOTAL functions I believe is this...

Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(22), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True

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)

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.

 

[DarthDiggler]

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